After Applying Oracle Database Patch Error ORA-6502 "Associative Array Shape Is Not Consistent" occur (Doc ID 436084.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 10.2.0.2 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 16-May-2013***

Symptoms

After applying Oracle Database Patchset version 10.2.0.3 the following intermittent error is occurring with a stored procedure:

ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters.

 

The stored procedure worked correctly before applying the Oracle Database patch.

This problem is sporadic and typically occurs at peak operating times. Usually the issue does not appear on test machines where only minimal loads exist.

This issue as been reported with:

* Running various Oracle Application WorkFlow processes
* High XML transactions
* Running PL/SQL procedures/functions.


There can be two variants of the ORA-06502 error:

  1. numeric or value error: associative array shape is not consistent with session parameters (PLS-01910)
  2. numeric or value error: character to number conversion error (PLS-01900)

Changes

Applied Oracle Database Patchset version 10.2.0.3.0  to the Oracle Database.

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