Home » SQL & PL/SQL » SQL & PL/SQL » doubt on exceptions (oracle 9i)
doubt on exceptions [message #318606] Wed, 07 May 2008 05:20 Go to next message
Messages: 38
Registered: February 2008
Location: Bangalore

suppose i ve written a pl/sql code in which there is a loop statement, the exception is when no_data_found.
then i want my loop to continue even when no data is retrieved from table.
so wat should be the code within the exception handler.

Thanks in advance.
Re: doubt on exceptions [message #318613 is a reply to message #318606] Wed, 07 May 2008 05:39 Go to previous message
Michel Cadot
Messages: 63920
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Put the exception handler inside the loop and not outside it.

Previous Topic: refcursors
Next Topic: Querying Dates missing in the table
Goto Forum:

Current Time: Tue Oct 25 04:27:08 CDT 2016

Total time taken to generate the page: 0.12703 seconds