Solved

# 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.

TIA