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 log procedure/function Input parameter values

2787926Jul 25 2017 — edited Jul 25 2017

Hello Every one ,I have a procedure with the three parameters and i want to log the procedure/function input parameters values , my scenario is like below 

create table param(obj_name varchar2(20),param_name varchar2(20));

table  values are like below

proc_cac      i_sum_val

proc_cal       i_multi_val

proc_cal       i_div_val

proc_audit    i_table_name

create or replace procedure proc_calc(i_sum_val in number,i_multi_val in number,i_div_val in number)

is

begin

----

for i in (select param_name  from param where obj_name ='proc_calc')

loop

dbms_output.put_line(i.param_name);

end loop;

---

end proc_cal;

exec param(12,13,14);

output :

i_sum_val

i_multi_val

i_div_val

Instead parameter name i want to display the actual parameter values like

output

12

13

14

is there any way to achieve this,  my database version is 11.2.0.4.0  ,

Thanks for the help 

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2017
Added on Jul 25 2017
1 comment
1,826 views