Page 1 of 1

ORA-06513 Error on Prepare.

Posted: Fri 31 Aug 2007 21:34
by delphidatadude
ORA-06513: PL/SQL: index for PL/SQL table out of range for host language array

For the past 5 years or so we have been using the ODAC components to access an Oracle stored procedure. this stored procedure returns string values. we have recently increase the number of values returned as Tparams to over 64. appearently we have reach some type of limitation of the TOraParams object.

Is there anyway to increase the number of parameters that can be successfully returned?

It looks as if I am using version 3.50, Delphi 6

Posted: Mon 03 Sep 2007 08:08
by Plash
Please specify the value of the Length property of the parameter. Length must be equal or more than number of values.

Promlem is not the size of the indivdual parameter

Posted: Thu 06 Sep 2007 19:38
by delphidatadude
but rather the number of parameters in the TOraStoredProc.PArams list.

we have over 65 parameters

Posted: Fri 07 Sep 2007 07:45
by Plash
We could not reproduce the problem. Please send to odac*crlab*com a complete small sample that demonstrates the problem, including script to create server objects.
Also specify the exact version of Oracle server and client. You can see it in the Info sheet of TOraSession Editor.

You can also try to upgrade ODAC to the last build of ODAC 3 (3.90.0.61) or to a newer version, and check if the error occurs.