Home » SQL & PL/SQL » SQL & PL/SQL » Cursor
Cursor [message #320443] Thu, 15 May 2008 02:38 Go to next message
Messages: 10
Registered: May 2008
Junior Member
How to check aparticular cursor is opened ornot

please explain with example

Re: Cursor [message #320451 is a reply to message #320443] Thu, 15 May 2008 02:55 Go to previous messageGo to next message
Messages: 1832
Registered: November 2006
Senior Member
Before using cursors, you shall learn something about them from the documentation, found eg. online on http://tahiti.oracle.com/.

PL/SQL User's Guide and Reference
Chapter 6 Performing SQL Operations from PL/SQL
Managing Cursors in PL/SQL
Explicit Cursors
Attributes of Explicit Cursors (link is for 10gR2)

It contains many nice examples too.
Re: Cursor [message #320453 is a reply to message #320443] Thu, 15 May 2008 02:56 Go to previous message
Messages: 2817
Registered: May 2007
Location: Scotland
Senior Member
Look up the PL/SQL documentation on managing cursors
please explain with example
The documentation will do so.

[edit] beat me to it

[Updated on: Thu, 15 May 2008 02:57]

Report message to a moderator

Previous Topic: ERROR 20005-:Number 259232 not found on wip queue
Next Topic: Need help with Sql query
Goto Forum:

Current Time: Fri Oct 21 04:28:06 CDT 2016

Total time taken to generate the page: 0.14388 seconds