How to print values of all my arguments automatically
529396Nov 23 2008 — edited Nov 25 2008within a procedure, I am thinking of printing the values of all arguments for debugging.
is there a way to do this in general,
without having to print each one explicitly.
many of my procedures can have dozens of arguments.
all my arguments are simple, varchar2, number, date.
but if there are ways to print compound arguments such as record,
collection,cursor, etc. that would be a great trick too.
create procedure p(p1 in varchar2, p2 in varchar2) is
begin
dbms_output.put_line('p1=' || p1);
dbms_output.put_line('p2=' || p2);
--logic of this procedure here
end;
dbms_describe can give me a list of argument names, data types and modes (IN, OUT or IN OUT).
Thanks for any pointers!