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.

Topics

• Syntax

• Semantics

• Examples

• Related Topics

Syntax

implicit_cursor_attribute ::=

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"

Related Topics

In this chapter:

• "FORALL Statement"

• "Named Cursor Attribute"

In other chapters:

• "Implicit Cursors"

• "Query Result Set Processing"