Home » SQL & PL/SQL » SQL & PL/SQL » Exception Handling
Exception Handling [message #195267] Wed, 27 September 2006 12:41 Go to next message
jkkandola
Messages: 5
Registered: September 2006
Junior Member
There are different methods to handle exception. If I want to look on exception messages, do i need to store them in table. is there standard package that deals with error?

Re: Exception Handling [message #195333 is a reply to message #195267] Thu, 28 September 2006 01:42 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Quote:

There are different methods to handle exception.
Are there? As far as I'm aware, you handle exceptions in an Exceptions block.

Quote:

If I want to look on exception messages, do i need to store them in table
No - Just inspect the value of SQLERRM to get the exception message.

Quote:

is there standard package that deals with error
Not that I can think of. What would such a package do?
Re: Exception Handling [message #195412 is a reply to message #195267] Thu, 28 September 2006 08:20 Go to previous messageGo to next message
jkkandola
Messages: 5
Registered: September 2006
Junior Member
Is there standard tool or package from oracle to log errors?
icon10.gif  Re: Exception Handling [message #195543 is a reply to message #195267] Fri, 29 September 2006 07:16 Go to previous message
vijayanarayanan
Messages: 11
Registered: September 2006
Location: chennai
Junior Member
Three different types of exceptions:

Pre-Defined
non pre-defined
user-defined

if you want to see the error give these two functions to get the error code and the error message:

Laughing give this in Exception others part:
SQLERRM(error message)
SQLCODE(error code)
Laughing
Previous Topic: retrieval time
Next Topic: Default sorting order
Goto Forum:
  


Current Time: Sun Dec 04 06:33:07 CST 2016

Total time taken to generate the page: 0.09754 seconds