PALLAVI

• Aug 24th, 2005

 

SQL%FOUND,SQL%NOT FOUND, SQL%IS OPEN, SQL%ROW COUNT

narasimhulu

 Profile Answers by narasimhulu 

• May 31st, 2006

 

hai

Sorry to tell you SQL%IS OPEN is not a valid implicit cursor attribute.

You will have SQL%FOUND,SQL%NOT FOUND,SQL%ROW COUNT as implicit cursor attirbutes

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

 

sql%isopen is there but it will always return "false" for implicit cursor

Haraprasad

 Profile Answers by Haraprasad 

• Nov 3rd, 2008

 

SQL%ISOPEN exists. Oracle always evaluates this to FALSE as PL/SQL closes implicit cursors immediately after they are executed.