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
LNPLS01311

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.

LNPLS1637Topics

Syntax

LNPLS1249named_cursor_attribute ::=

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

LNPLS1250named_cursor ::=

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

Semantics

LNPLS1671named_cursor_attribute

LNPLS1255%ISOPEN

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

LNPLS1256%FOUND

named_cursor%FOUND has one of these values:

LNPLS1257%NOTFOUND

named_cursor%NOTFOUND has one of these values:

LNPLS1258%ROWCOUNT

named_cursor%ROWCOUNT has one of these values:

LNPLS1673named_cursor

LNPLS1251explicit_cursor

Name of an explicit cursor.

LNPLS1252cursor_parameter

Name of a formal cursor parameter.

LNPLS1253cursor_variable

Name of a cursor variable.

LNPLS1254: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

LNPLS1674In this chapter:

LNPLS1675In other chapters:

Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF