Bind Values Misordered After Loading Large PL/SQL Unit Without Carriage Returns (Doc ID 1386413.1)

Last updated on JANUARY 25, 2012

Applies to:

PL/SQL - Version: 10.2.0.1 to 11.2.0.3 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

When loading a large PL/SQL program unit (package, procedure, function, or trigger) that does not contain any line feeds or carriage returns using SQL*Developer or some other API or tool besides SQL*Plus, the PL/SQL code contains SQL queries that returns wrong results or DML statements that are either failing with strange errors such as ORA-01722 or end up affecting the wrong rows. When looking closer using a SQL trace, the bind values appear to be out of order or corrupt.

Changes

Stripped line feeds or carriage returns or perhaps the code has been modified and now exceeds 64K characters or causes a SQL statement with binds to span both sides of the 64K boundary.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms