My Oracle Support Banner

Implicit Cursor Attributes Such As SQL%ROWCOUNT Changing After Procedure or Function Call (Doc ID 3055101.1)

Last updated on OCTOBER 29, 2024

Applies to:

PL/SQL - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Given code of the following form ...

  1. Run a query or DML using an implicit cursor.
  2. Call a procedure or function.
  3. Check any implicit cursor attribute such as SQL%ROWCOUNT.

The value returned in step 3 may or may not be the same as it was prior to the call to the procedure or function.

Changes

The code for the procedure or function has changed to use an implicit cursor, no implicit cursor was used prior to the change.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.