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: 64953
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: Sun Jun 25 17:44:43 CDT 2017

Total time taken to generate the page: 0.13476 seconds