Home » SQL & PL/SQL » SQL & PL/SQL » cursors
cursors [message #223151] Wed, 07 March 2007 14:52 Go to next message
AGARWALNIRU
Messages: 13
Registered: March 2007
Junior Member
can more then one cursors be defined inside a procedure
Re: cursors [message #223156 is a reply to message #223151] Wed, 07 March 2007 15:03 Go to previous messageGo to next message
riteshsj
Messages: 2
Registered: March 2007
Location: California
Junior Member
yes...you may have more than one cursor
Re: cursors [message #223351 is a reply to message #223156] Thu, 08 March 2007 10:23 Go to previous messageGo to next message
AGARWALNIRU
Messages: 13
Registered: March 2007
Junior Member
thanks!!!
Re: cursors [message #223703 is a reply to message #223156] Sat, 10 March 2007 09:27 Go to previous messageGo to next message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
...although it is rare that you would want to Wink
Re: cursors [message #223899 is a reply to message #223703] Mon, 12 March 2007 04:09 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
But how else can you do nested cursor for loops without multiple cursors....
Cool
Re: cursors [message #223903 is a reply to message #223899] Mon, 12 March 2007 04:18 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
simple: use dynamic sql! Gives you the opportunity to create your temporary tables as well!
Re: cursors [message #223929 is a reply to message #223903] Mon, 12 March 2007 05:07 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
And drop them too.
Re: cursors [message #224063 is a reply to message #223929] Mon, 12 March 2007 17:03 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
Anyway there would be no point naming a cursor "c1" if there wasn't also a "c2".
Previous Topic: Regarding buffer overflow error
Next Topic: how to fill gap between two dates
Goto Forum:
  


Current Time: Sat Dec 03 14:16:13 CST 2016

Total time taken to generate the page: 0.04379 seconds