OraFAQ Forum: SQL & PL/SQL » Dynamic %rowtype

Home » SQL & PL/SQL » SQL & PL/SQL » Dynamic %rowtype (Oracle 10g)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Switch to threaded view of this topic

Create a new topic

Submit Reply

Dynamic %rowtype [message #575661]

Fri, 25 January 2013 04:48

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

Report message to a moderator

Send a private message to this user

Re: Dynamic %rowtype [message #575662 is a reply to message #575661]

Fri, 25 January 2013 04:53

Littlefoot
Messages: 16993
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

A weak ref cursor variable?

Report message to a moderator

Send a private message to this user

Re: Dynamic %rowtype [message #575663 is a reply to message #575661]

Fri, 25 January 2013 04:54

Michel Cadot
Messages: 54226
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

Report message to a moderator

Send a private message to this user

Switch to threaded view of this topic

Create a new topic

Submit Reply

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 04:40:08 CDT 2013

Total time taken to generate the page: 0.19362 seconds