Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to get call stack?

How to get call stack?

From: Oleg Roshchin <oleg_at_ca-ib.com>
Date: Tue, 27 Jul 1999 11:53:25 +0400
Message-ID: <7njohh$o9j$1@news.netway.at>


Hi all!

How can I get call stack for any procedure or trigger? I assume it's possible because Oracle show this information in case of error.
I need this information to write it in my own log-file, for example if my "before update trigger" is fired I need to know (and to write into my log-file) which procedure or another trigger called (or caused) this trigger execution.

Thanks in advance.

Oleg
Moscow,
Russia
oleg_at_ca-ib.com Received on Tue Jul 27 1999 - 02:53:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US