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 -> Re: Tracing session

Re: Tracing session

From: Martin Haltmayer <Martin.Haltmayer_at_d2mail.de>
Date: Mon, 24 Dec 2001 12:53:07 +0100
Message-ID: <3C271723.D8AF38EA@d2mail.de>


Hi Henry,

have a look at sys.dbms_utility.format_call_stack. It will return a big string containing the current call sequence from within the invoking procedure.

Regards,

Martin

Henry wrote:
>
> Hi,
>
> If I want to trace another session but want to see also which stored
> procedures does it call (and what are parameter values). Is there a way to
> get that information from database?
> Thanks for an advice.
>
> Henry
Received on Mon Dec 24 2001 - 05:53:07 CST

Original text of this message

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