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!

Calling Oracle procedure with two OUT parameters

user625850Jun 20 2012 — edited Jun 20 2012

Hi I am having an Oracle procedure which return ref cursor. I also want to result one more out parameter result. How Can I call the procedure in SQL. Below is the way I am calling my stored procedure with one parameter.

proc_Test (p_resultset=> My_cursor)

How can I call the procedure when I have one more OUT parameter. Second parameter returns 0 or 1.

Thanks in adv

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 18 2012

Added on Jun 20 2012

5 comments

138,605 views