السلام عليكم
Assume that i have a procedure pro1 which accept two parameters as follow :
1- p1 number
2- p2 varchar2
And i'm calling the procedure as pro1(p1=>5,p2=>'Any string') ;
What i need is :
Register the name of parameter and it's value as json object like {"p1":5,"p2":"Any string"} dynamically any time when calling the procedure.
I know there is a view called "all_arguments" and i can get the name of parameters but the point is
how can i get the value
Thanks