Two Laptop Bag*
The moose likes Oracle/OAS and the fly likes How to Pass Cursor Row as a parameter to another Function? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How to Pass Cursor Row as a parameter to another Function?" Watch "How to Pass Cursor Row as a parameter to another Function?" New topic
Author

How to Pass Cursor Row as a parameter to another Function?

Sandeep John
Greenhorn

Joined: Jun 29, 2011
Posts: 3
Hi All,

I Have Cursor



Now I need to pass each row from cursor ABC as a parameter to FUNCTION().

Can some one tell me how to do that?

Gene Hilpert
Ranch Hand

Joined: May 22, 2002
Posts: 51

I'm not sure if you want to call the function for each row in the select or if you want pass the cursor to the function.
For the first case include the function in the select
I.E.


For the second



Then call it like:


Hope this helps.

Sandeep John
Greenhorn

Joined: Jun 29, 2011
Posts: 3
I guess you dint get my question correctly, Let me explain more detail..

From above example I have Cursor ABC.

Instead of doing
FUNCTION(REC.Col1, REC.Col2, REC.Col3)


I wanna send each record completely, what is the correct procedure of doing below

FUNCTION(REC);

Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

Welcome to the Ranch, Sandeep!

Please re-read Gene's answer. Does it pass individual columns from the cursor to the function or not?

Alternatively, you might perhaps use the %ROWTYPE attribute.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to Pass Cursor Row as a parameter to another Function?
 
Similar Threads
Error in jdbc while executing procedure
JDBC & oracle function
How I can pass Cursor as In parameter
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state
bean message in javascript