File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Sandeep John
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 51
Eclipse IDE Hibernate Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 3747
62
Chrome Netbeans IDE Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic