Home » SQL & PL/SQL » SQL & PL/SQL » exception handling
exception handling [message #232924] Tue, 24 April 2007 01:57 Go to next message
sheelapj
Messages: 3
Registered: April 2007
Junior Member
hi
can we specify an exception handler to perform final actions instead of terminating when an exception is raised
Re: exception handling [message #232935 is a reply to message #232924] Tue, 24 April 2007 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't specify an exception handler but you can enclose any part of your code between "begin exception end" to handle exceptions.

Regards
Michel
Re: exception handling [message #233757 is a reply to message #232935] Fri, 27 April 2007 06:25 Go to previous messageGo to next message
sheelapj
Messages: 3
Registered: April 2007
Junior Member
Michel Cadot wrote on Tue, 24 April 2007 02:39
You can't specify an exception handler but you can enclose any part of your code between "begin exception end" to handle exceptions.

Regards
Michel


Re: exception handling [message #233758 is a reply to message #233757] Fri, 27 April 2007 06:28 Go to previous message
sheelapj
Messages: 3
Registered: April 2007
Junior Member
hi Michel,

thnks for the response.yes i have found the answer from oracle user's guide.It was very informative and practical.

thnks and regards
sheela
Previous Topic: Very Good Doubt in PL/SQL
Next Topic: how to reading CLOB contains 20000 characters.
Goto Forum:
  


Current Time: Wed Dec 07 18:21:59 CST 2016

Total time taken to generate the page: 0.22170 seconds