Passing values between procedures(without actually passing them)

From: LPF <eng.lpsff_at_gmail.com>
Date: Fri, 29 Jan 2010 05:09:21 -0800 (PST)
Message-ID: <0582a223-0cdb-4b32-945e-aa9c20d9a0c2_at_q4g2000yqm.googlegroups.com>



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;

The point to this is that i have a lot of procedures(like Procedure1) calling a Procedure(Procedure2).
So if this could be achieved, i only have to use a simple line like "Procedure2;" to all procedures(and with the advantage of not being dependent of the number of parameteres, so future changes wouldn't affect the Procedure2 call).

Thx in advance. Received on Fri Jan 29 2010 - 07:09:21 CST

Original text of this message