Hello,
I am writing a dynamic function in which number of columns to be retrieved change depending on the parameter values passed while invoking the function. I am using CROSSTAB in the dynamic SQL.
Once I prepare a dynamic SQL and I execute, I want the entire result set from the executed SQL to be returned to function RETURN.
Is this possible? If yes, can you please point me to some examples.
Thanks,
Sarwar