Hey,
I have a parameter list that I want to get each of he parameters in it and it's value.
I have the parameter names, BUT I'm not sure that all the parameters are inserted into the list. Some of it may be omitted because they have default values...
Anyway, I'm using the GET_PARAMTER_ATTR built-in to get the values for the known parameters, but when I use it on a parameter that is not inserted into the list, I get an error: "FRM-47026: Cannot get parameter <parameter name> attributes from Parameter List <parameter list name> -- no such named parameter exists".
I've tried to pad this command with BEGIN-END-EXCEPTION and to ignore the error with "when other then" section in the EXCEPTION, but the message still appears...
How can i ignore the error, so that the parameters that the application did not inserted to the parameter list won't create an error that the user will see.
If this cannot be done, how can I know the list pf parameters name that the parameter list contains?
10x,
Gilad.