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!

can Function return multiple values?

Dir_PalMar 21 2018 — edited Mar 27 2018

I have procedure in a package  with in and out parameters

1) Can we convert this procedure to function returning multiple value

2) if we can return multiple value in function .. can we call it in select statement.

3) Is it advisable to use multiple values in a function.

4) so if I want to use the value  in procedure what can I do it in select statement.

Edit: after

Sven W.Hero    Reply 

Sven W

4) I have in and out parameters in procedure and I want to use that value in select statement how can I use it? is it possible?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2018
Added on Mar 21 2018
27 comments
4,290 views