Like to RETURN SQL results set

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

 

 

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