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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Put the exception handler inside the loop and not outside it.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 04 19:15:10 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.