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

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

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

Named Cursor Attribute

Every named cursor (explicit cursor or cursor variable) has four attributes, each of which returns information about the execution of a DML statement.

Note:

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

Topics

Syntax

named_cursor_attribute ::=

Description of named_cursor_attribute.gif follows
Description of the illustration named_cursor_attribute.gif

named_cursor ::=

Description of named_cursor.gif follows
Description of the illustration named_cursor.gif

Semantics

named_cursor_attribute

%ISOPEN

named_cursor%ISOPEN has the value TRUE if the cursor is open, and FALSE if it is not open.

%FOUND

named_cursor%FOUND has one of these values:

%NOTFOUND

named_cursor%NOTFOUND has one of these values:

%ROWCOUNT

named_cursor%ROWCOUNT has one of these values:

named_cursor

explicit_cursor

Name of an explicit cursor.

cursor_parameter

Name of a formal cursor parameter.

cursor_variable

Name of a cursor variable.

:host_cursor_variable

Name of a cursor variable that was declared in a PL/SQL host environment and passed to PL/SQL as a bind variable. Do not put space between the colon (:) and host_cursor_variable.

Examples

Related Topics

In this chapter:

In other chapters: