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!

Initialize Ref Cursor to Avoid ORA-01001: invalid cursor

Christine1111Feb 1 2013 — edited Feb 4 2013
Hi,

I'm writing a stored procedure that will return a REF CURSOR. However, there are times when the cursor will not be opened if certain conditions are not met, so I'm wondering if there's a way to initialize the REF CURSOR so that the caller doesn't receive the "ORA-01001: invalid cursor" error when trying to work with the cursor if it has not been opened.

Any help is greatly appreciated...

Thanks,
Christine
This post has been answered by Karthick2003 on Feb 4 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2013
Added on Feb 1 2013
6 comments
1,964 views