Re: Passing values between procedures(without actually passing them)

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 29 Jan 2010 09:35:33 -0700
Message-ID: <4b631c65$1_at_news.victoria.tc.ca>



LPF (eng.lpsff_at_gmail.com) wrote:
: It's possible to achieve something like this?

: Procedure1(param1,param2) IS
: ...
: begin
: Procedure2;
: end Procedure1;

: Procedure2 IS
: ....
: begin
: --Know the parameters values of Procedure1 at this point(with
: dbms_debug, dbms_trace, some V$, ....)
: end Procedure2;

DBMS_UTILITY.FORMAT_ERROR_BACKTRACE might help do this. And while checking the documentation for that one you should look for other related procedures in the same part of the manual.

Tom Kyte (who else) has some examples of it's usage. Received on Fri Jan 29 2010 - 10:35:33 CST

Original text of this message