PL/SQL (MOSC)

MOSC Banner

How to fetch data from dynamic sql where no. of columns are varying

edited Dec 15, 2010 10:55PM in PL/SQL (MOSC) 8 commentsAnswered
 Hi Gurus,

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center