PL/SQL: dynamically determining parameter names and values

From: Jeremy <jeremy0505_at_gmail.com>
Date: Mon, 13 Nov 2006 09:24:24 -0000
Message-ID: <MPG.1fc24a1ad800b99d98a34d@news.individual.net>

Oracle 9iR2

I would like to be able to generically write out to a table the parameter names of a stored procedure and the value that each parameter had. For example:

procedure p

	(p1          in     varchar2,
        p2          in     varchar2,
        p3          in     varchar2)

is
begin
--

• write to logfile
  --
  insert into logtab(pname, pvalue) values ('p1',p1);

  insert into logtab(pname, pvalue)
  values ('p2',p2);

  insert into logtab(pname, pvalue)
  values ('p3',p3);
end;

Ignoring data type conversions etc. (plus the functional requirements here....) for the time being, what I would like to be able to do is have a block of code that would be able to loop through the parameter names and give me the name and value pairs such that if I could use it in any procedure.

I don't think it's possible but would be delighted to to be proved wrong.

cheers

-- 
jeremy

 ============================================================
   ENVIRONMENT:                                             
   Oracle 9iR2 / Oracle HTTP Server / mod_plsql / Solaris 8 
 ============================================================

Received on Mon Nov 13 2006 - 03:24:24 CST