Re: Passing values between procedures(without actually passing them)
Date: Fri, 29 Jan 2010 18:45:22 -0500
Message-ID: <uockcfpbh.fsf_at_www.yahoo.com>
LPF <eng.lpsff_at_gmail.com> writes:
> 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.
You could look at the object oriented features. Set variables on an object then call a member function/procedure could accomplish this.
-- Galen Boyer --- news://freenews.netfront.net/ - complaints: news_at_netfront.net ---Received on Fri Jan 29 2010 - 17:45:22 CST