My Oracle Support Banner

Exception Handling Behavior With DBMS_LOB.READ() Between 9.2 AND 11G (Doc ID 970516.1)

Last updated on FEBRUARY 23, 2019

Applies to:

PL/SQL - Version 9.2.0.1 to 11.2.0.1 [Release 9.2 to 11.2]
Information in this document applies to any platform.

Symptoms

In PL/SQL, if the type of an IN/OUT or OUT variable isn't _exactly_ the same as the parameter declaration, the output value will be lost if an exception is thrown where a NOCOPY hint is used.

This is causing a behavioral difference with the DBMS_LOB.READ() call across versions.

The following testcase scenario demonstrates the resulting value of "0" where the value is lost depending on the datatype of the variable and the RDBMS version.

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
References


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