How to fetch data from dynamic sql where no. of columns are varying
I have written a package where i am using ref cursor and dynamic sql to fetch the data and inserting into some global temporary table.
My requirement is that no of columns are changing in select statement.Hence i can't declare record of with same no if coulmns because no of collumns are known at run time only.
How to achieve this.
Please help!!!!
Thanks,
Mahesh