Implicit Cursor Attribute

13.39 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.

Note:

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

Topics

Syntax

implicit_cursor_attribute ::=

Description of the illustration implicit_cursor_attribute.eps

Semantics

%ISOPEN

SQL%ISOPEN always has the value FALSE.

%FOUND

SQL%FOUND has one of these values:

If no SELECT or DML statement has run, NULL.
If the most recent SELECT or DML statement returned a row, TRUE.
If the most recent SELECT or DML statement did not return a row, FALSE.

%NOTFOUND

SQL%NOTFOUND has one of these values:

If no SELECT or DML statement has run, NULL.
If the most recent SELECT or DML statement returned a row, FALSE.
If the most recent SELECT or DML statement did not return a row, TRUE.

%ROWCOUNT

SQL%ROWCOUNT has one of these values:

If no SELECT or DML statement has run, NULL.
If a SELECT or DML statement has run, the number of rows fetched so far.

SQL%BULK_ROWCOUNT

Composite attribute that is like an associative array whose ith element is the number of rows affected by the ith DML statement in the most recently completed FORALL statement. For more information, see "Getting Number of Rows Affected by FORALL Statement".

Restriction on SQL%BULK_ROWCOUNT

You cannot assign the value of SQL%BULK_ROWCOUNT(index) to another collection.

SQL%BULK_EXCEPTIONS

Composite attribute that is like an associative array of information about the DML statements that failed during the most recently run FORALL statement. SQL%BULK_EXCEPTIONS.COUNT is the number of DML statements that failed. If SQL%BULK_EXCEPTIONS.COUNT is not zero, then for each index value i from 1 through SQL%BULK_EXCEPTIONS.COUNT:

SQL%BULK_EXCEPTIONS(i).ERROR_INDEX is the number of the DML statement that failed.
SQL%BULK_EXCEPTIONS(i).ERROR_CODE is the Oracle Database error code for the failure.

Typically, this attribute appears in an exception handler for a FORALL statement that has a SAVE EXCEPTIONS clause. For more information, see "Handling FORALL Exceptions After FORALL Statement Completes".

Examples

Example 6-3, "SQL%FOUND Implicit Cursor Attribute"
Example 6-4, "SQL%ROWCOUNT Implicit Cursor Attribute"
Example 6-15, "%FOUND Explicit Cursor Attribute"
Example 6-14, "%ISOPEN Explicit Cursor Attribute"
Example 6-16, "%NOTFOUND Explicit Cursor Attribute"
Example 6-17, "%ROWCOUNT Explicit Cursor Attribute"
Example 12-13, "Handling FORALL Exceptions After FORALL Statement Completes"
Example 12-14, "Showing Number of Rows Affected by Each DELETE in FORALL"
Example 12-15, "Showing Number of Rows Affected by Each INSERT SELECT in FORALL"