Re: Generic code for looking at pl/sql stored procedure arguments

Jeremy wrote:
>
> Say I have a procedure
>
> create or replace procedure p
> (p_string in varchar2 default null,
> p_date in date)
> is
> ..
> ..
> ..
>
> If I wanted to recrod the execution of this procedure I could simply
> write e.g.
>
> l_call := 'p : p_string='||p_string|| ' : ' p_date='||p_date);
>
> My question: is there a generic way of extcating the name of the
> procedure being run together with the arguments used to call it?
>
> I suspect not......
>
> Environment: 9iR2 / Solaris8
>
> --
>
> jeremy

check out 'all_arguments'

you can also use dbms_utility.format_call_stack to work out the name of the procedure you are currently running

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------