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


please explain with example



Thanx
Re: Cursor [message #320451 is a reply to message #320443] Thu, 15 May 2008 02:55 Go to previous messageGo to next message
flyboy
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
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Look up the PL/SQL documentation on managing cursors
Quote:
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 Dec 02 18:22:02 CST 2016

Total time taken to generate the page: 0.44918 seconds