Generic code for looking at pl/sql stored procedure arguments

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Mon, 21 Mar 2005 18:16:46 -0000
Message-ID: <MPG.1ca91fe0b2faacb7989de3@news.individual.net>

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

Received on Mon Mar 21 2005 - 12:16:46 CST