I have run into an issue with retrieving the parameters sent into a procedure. This proc has around 160 IN params and I have to run every single one if them through a function for auditing purposes. I am trying to clean up my code by getting all of the values for the parameters without having to go through them one by one and grab the value.
If I can get the values when they come in I can use a LOOP and clean up my code dramaticly. I get the parameter list from ALL_ARGUMENTS, so now I just need the values. So my question is this, is there anywhere in the data dictionary that holds these values that I can select from, or somehow get them from metadata?