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
sharathmpatil
Messages: 38
Registered: February 2008
Location: Bangalore
Member

hi,
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: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Put the exception handler inside the loop and not outside it.

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


Current Time: Sat Dec 10 12:56:53 CST 2016

Total time taken to generate the page: 0.04044 seconds