Skip Headers
Oracle® Database PL/SQL Language Reference
11g Release 2 (11.2)

Part Number E17126-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

Implicit Cursor Attribute

An implicit cursor has attributes that return information about the most recently run SELECT or DML statement that is not associated with a named cursor.



implicit_cursor_attribute ::=

Description of the illustration implicit_cursor_attribute.gif



SQL%ISOPEN always has the value FALSE.


SQL%FOUND has one of these values:


SQL%NOTFOUND has one of these values:


SQL%ROWCOUNT has one of these values:


A composite attribute for use with the "FORALL Statement". This attribute acts like an associative array. Its ith element stores the number of rows processed by the ith execution of an UPDATE or DELETE statement. If the ith execution affects no rows, SQL%BULK_ROWCOUNT(i) has the value zero. For more information, see "Counting Rows Affected by FORALL".

Restriction on SQL%BULK_ROWCOUNT You cannot assign the value of SQL%BULK_ROWCOUNT(index) to another collection or pass it as a parameter to a subprogram.


A composite attribute for use with a FORALL statement that has a SAVE EXCEPTIONS clause (see "FORALL Statement"). This attribute acts like an associative array that stores information about any exceptions raised while the FORALL statement ran. For each index value i between 1 and SQL%BULK_EXCEPTIONS.COUNT:

For more information, see "Effect of FORALL Exceptions on Rollbacks" and "Exception Handling in FORALL Statements".


You can use cursor attributes in procedural statements, but not in SQL statements.


Related Topics

In this chapter:

In other chapters: