ORA-06513 Error on Prepare.

delphidatadude · Post by **delphidatadude** » Fri 31 Aug 2007 21:34

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

Plash · Post by **Plash** » Mon 03 Sep 2007 08:08

Please specify the value of the Length property of the parameter. Length must be equal or more than number of values.

delphidatadude · Post by **delphidatadude** » Thu 06 Sep 2007 19:38

but rather the number of parameters in the TOraStoredProc.PArams list.

we have over 65 parameters

Plash · Post by **Plash** » Fri 07 Sep 2007 07:45

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.

Devart Forums

ORA-06513 Error on Prepare.

ORA-06513 Error on Prepare.

Promlem is not the size of the indivdual parameter