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

From: <lambu999_at_yahoo.com>
Date: 30 Mar 2005 14:29:37 -0800
Message-ID: <1112221777.801926.98200@g14g2000cwa.googlegroups.com>

Jeremy,

If I understand what you are saying, you want to record the name of the procedure as well as the *value* of the arguments with which it is called - every time the procedure is called. I assume you want to do some kind of auditing on every call.

One thought comes to my mind: How about adding a small piece of code in the beginning of the procedure itself to record the arguments into your audit table. Alternately you can create a small generic procedure (say, record_arguments) and call the generic procedure from your original procedure with the arguments with which your original procedure is called. i.e. call record_arguments from original procedure. record_arguments in turn can write the information into your audit table.

I dont know about the possible issues with this case though. Hope others will point out if there are potential issues with this idea.

Ram.

---

Jeremy wrote:
> In article <1111438306.802569.153630_at_f14g2000cwb.googlegroups.com>,
> rjamya_at_gmail.com says...
> > Try selecting from all_arguments view ...
>
> Thanks but that only tells me the argumnt spec what I am after is the

> values for each argument supplied for each invocation of the
procedure -
> and a call that is performed within the procedure itself.
>
> cheers
>
Received on Wed Mar 30 2005 - 16:29:37 CST