Home » SQL & PL/SQL » SQL & PL/SQL » how to dynamically declare a cursor based on the parameter passed to the proc!!!!!
how to dynamically declare a cursor based on the parameter passed to the proc!!!!! [message #2003] Sat, 15 June 2002 19:51 Go to next message
mani
Messages: 105
Registered: September 1999
Senior Member
hai oragurus,,,,,
i have one procedure whcih has one parameter.....inside of that procedure am declaring the cursor using that parameter....that parameter is nothing but the table name.....so here at runtime....depending upon the table name the cursor definition should be changed.....

how can i achieve this?????
I need help....
Thanks in advance
Mani

Report message to a moderator

Re: how to dynamically declare a cursor based on the parameter passed to the proc!!!!! [message #2008 is a reply to message #2003] Sun, 16 June 2002 07:47 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
please refer to our posting at
Re: Question Selecting All Columns According To The User Input

Report message to a moderator

Previous Topic: select data which does not in join condition
Next Topic: Temporary Table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 13:02:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.