Home » SQL & PL/SQL » SQL & PL/SQL » Exception context information
Exception context information [message #41010] Sat, 16 November 2002 07:43 Go to next message
Vaidas
Messages: 2
Registered: November 2002
Junior Member
When I get an exception in PL/SQL I would like to log something more than sqlcode, for example I would like to store package name, procedure name and the line number where the exception has occured.
How could I get such information?
Maybe it is possible to get current call stack too?

Report message to a moderator

Re: Exception context information [message #41021 is a reply to message #41010] Mon, 18 November 2002 11:01 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Search for format_call_stack and format_error_stack on this site. There are some limitations, but it's useful.

Report message to a moderator

Re: Exception context information [message #41023 is a reply to message #41010] Mon, 18 November 2002 17:38 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9091
Registered: November 2002
Location: California, USA
Senior Member
Tom Kyte wrote a couple of functions, who_am_I and who_called_me that may be of some help. Click on the link below for more info:

Report message to a moderator

Re: Exception context information [message #41026 is a reply to message #41010] Tue, 19 November 2002 02:34 Go to previous message
Vaidas
Messages: 2
Registered: November 2002
Junior Member
Thank you Andrew, Todd and Barbara for valuable help. I had spent all Sunday afternoon looking for something useful in Oracle documentation, but didn't find anything. I know, what is possible in Oracle.

Vaidas

Report message to a moderator

Previous Topic: still connecting problem
Next Topic: What is a # (hash or pound) sign used for in a column name?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 05:26:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.