ORA-20001 ORA-6502 calling procedure that uses FND_GLOBAL.APPS_INITIALIZE via Oracle Provider for Ole Db (ORAOLEDB) (Doc ID 1489211.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Provider for OLE DB - Version 10.2.0.5 and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

***Checked for relevance on 06-Sep-2015***

Symptoms

Trying to execute a stored procedure that relies on Oracle Applications provided FND_GLOBAL.APPS_INITIALIZE from an application that connects using the Oracle Provider for Ole Db  (ORAOLEDB) may result in the following error:

ORA-20001: Oracle error -6502: ORA-06502: PL/SQL: numeric or value error: character string buffer too small


Calling the same stored procedure from sqlplus or other API's may complete without errors.

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