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