Calling a Package Procedure or Standalone Procedure With Syntax Schema.ProcName may Fail with ORA-6513 with a large number of Parameters

(Doc ID 1273381.1)

Last updated on APRIL 04, 2012

Applies to:

Oracle ODBC Driver - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Generic Windows

Symptoms

Calling a stored procedure with a large parameter signature and prefixing the procedure name with the owner or schema name fails with:

Failed - [Oracle][ODBC][Ora]ORA-06513: PL/SQL: index for PL/SQL table out of ran ge for host language array ORA-06512: at line 1

Changes

Prefix the procedure name with schema or owner and/or the number of parameters increased.

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