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

What do you mean by generic and extract when? It matters.

If you are talking about real-time, in production, no. Otherwise one can use DBMS_DEBUG or DBMS_APPLICATION_INFO without impacting resources. In 10g look too at DBMS_MONITOR.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)