Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Return a Collection in a function

sql_coderMay 20 2010 — edited May 21 2010
Hello oracle,

our Java developer calls a PL/SQL function and he gets a VARCHAR in return, that works well so far. Now I would like to return a collection. But I am not sure how to do it, since I need to define the collection inside the function. Maybe thats a simple task, but I dont know where to start to return a collection. Any suggestions or a link, maybe it is not possible at all ?

Ikrischer
This post has been answered by 758358 on May 20 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 18 2010
Added on May 20 2010
5 comments
3,472 views