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 ::=
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"
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4