PL/SQL function problem
Posted on 2003-03-13
Hi I want to create a PL/SQL function, but I don't know how to go about it
Basically I want to feed in a number of variables and I want the function to return me a string saying which of the variables are null.
The call to the function will go as follows
output_string := get_null_values ('Value 1',value_1,'Value 2',value_2,...)
This would return 'Value x, Value y, Value z,... are null'
This would be easy to write for a specified number of input parameters, but I want the function to work no matter how many input parameters I use, as long as they are in the pattern above.
Oracle built in functions such as Greatest, Least etc. seem to work for an arbitrary number of parameters, but I have no idea how I would code one myself.
Any advice would be much appreciated.