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: 65144
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: Rewriting Query
Next Topic: refcursors
Goto Forum:
  


Current Time: Sun Aug 20 14:26:21 CDT 2017

Total time taken to generate the page: 0.09315 seconds