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?
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