Home » SQL & PL/SQL » SQL & PL/SQL » Dynamic %rowtype (Oracle 10g)
Dynamic %rowtype [message #575661] Fri, 25 January 2013 04:48 Go to next message
Messages: 15
Registered: November 2012
Location: Bangalore,India
Junior Member

im trying to select columns from different tables dynamically in a function . The parameter for the function will be table name and column id's, In this number of columns may vary . Is it possible to have dynamic %rowtype to store the cursor value in it.

Re: Dynamic %rowtype [message #575662 is a reply to message #575661] Fri, 25 January 2013 04:53 Go to previous messageGo to next message
Messages: 21123
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
A weak ref cursor variable?
Re: Dynamic %rowtype [message #575663 is a reply to message #575661] Fri, 25 January 2013 04:54 Go to previous message
Michel Cadot
Messages: 64967
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or in other word: SYS_REFCURSOR.
But take care, you are at the gates of hell.

Previous Topic: how can we create table by using another table with some condition
Next Topic: forall update with bulk collect for multiple columns
Goto Forum:

Current Time: Wed Jun 28 22:58:07 CDT 2017

Total time taken to generate the page: 0.17358 seconds