Tuesday, 22 May 2012

Why does SQL%ISOPEN always returns the FALSE value? | PL SQL

 SQL is the name of the implicit cursor, which is always opened when the database executes the SQL statement. SQL%ISOPEN always evaluates to FALSE as ORACLE closes the implicit cursor as soon as it executes the query.