Home » SQL & PL/SQL » SQL & PL/SQL » to compare with sys_refcursor what could be the possible values other than %NOTFOUND?? (Oracle 10g)
to compare with sys_refcursor what could be the possible values other than %NOTFOUND?? [message #378684] Wed, 31 December 2008 05:37 Go to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

to compare with sys_refcursor what could be the possible values other than %NOTFOUND?? Cool

[Updated on: Wed, 31 December 2008 07:02]

Report message to a moderator

Re: to compare with sys_refcursor what could be the possible values other than %NOTFOUND?? [message #378694 is a reply to message #378684] Wed, 31 December 2008 07:31 Go to previous message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

rtnataraj wrote on Wed, 31 December 2008 17:07
to compare with sys_refcursor what could be the possible values other than %NOTFOUND?? Cool

%NOTFOUND is one of the four cursor attributes ( %FOUND , %ISOPEN and %ROWCOUNT are the others) which give us information about the state of our cursors

[Updated on: Wed, 31 December 2008 07:32]

Report message to a moderator

Previous Topic: Reg Check constraint over a particular column
Next Topic: Need to Update 20 million records of data
Goto Forum:
  


Current Time: Fri Dec 06 15:14:26 CST 2024