Home » SQL & PL/SQL » SQL & PL/SQL » Catch Exceptions
Catch Exceptions [message #242998] Tue, 05 June 2007 12:39 Go to next message
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
Member
Whenever exception throws ,i want to store more information in log file for debugging purpose.
How can we find that the exception throws from which line in the Procedure or package ?
Is there any way to find this ?

[Updated on: Tue, 05 June 2007 12:40]

Report message to a moderator

Re: Catch Exceptions [message #243000 is a reply to message #242998] Tue, 05 June 2007 12:54 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at FORMAT_CALL_STACK, FORMAT_ERROR_BACKTRACE and FORMAT_ERROR_STACK functions.

Regards
Michel
Previous Topic: group by... ORA-22818 subquery expression not allowed here"
Next Topic: nested subqueries
Goto Forum:
  


Current Time: Sun Dec 11 06:10:46 CST 2016

Total time taken to generate the page: 0.09105 seconds