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
visitsenthil
Messages: 15
Registered: November 2012
Location: Bangalore,India
Junior Member
Hi,

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.

Regards,
Senthil
Re: Dynamic %rowtype [message #575662 is a reply to message #575661] Fri, 25 January 2013 04:53 Go to previous messageGo to next message
Littlefoot
Messages: 19890
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: 60012
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.

Regards
Michel
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: Sun Dec 21 13:56:14 CST 2014

Total time taken to generate the page: 0.09533 seconds