Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to print values of all my arguments automatically

529396Nov 23 2008 — edited Nov 25 2008
within 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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2008
Added on Nov 23 2008
4 comments
503 views