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 fetch NO DATA FOUND exception in Ref Cursor.

686951Jun 18 2009 — edited Jun 25 2009
In my procedure ref cursor is out parameter with returns dataset. in my proceudre

its like...

OPEN pPymtCur FOR
select.....


when I call this procedure from report to get dataset it causes NO DATA FOUND exception.

How to fetch this exception in my oracle procedure so I can get some other data.

Any Idea to do this?

Edited by: Meghna on 17-Jun-2009 22:28
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2009
Added on Jun 18 2009
7 comments
5,492 views