Skip to Main Content
Forums

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!

How to return two values from a function?

715318Sep 11 2009 — edited Sep 14 2009
Hi All,
I've a function which returns a varchar2 value. This value is used in the SQL of a ref cursor.

Now I want this function to return two values. I tried using varray but couldn't accomplish the task.

Can you tell me how can I return two values from a function? and how can this function be called in a SQL query?

Many Thanks
This post has been answered by William Robertson on Sep 14 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2009
Added on Sep 11 2009
19 comments
1,965 views