christian
User
Junior Boarder
| Posts: 11 |   |
Karma: 0
|
|
PL/SQL index for PL/SQL table out of range
|
|
Posted: 2008/03/26 08:38 |
|
|
|
|
I have one procedure that when executed with StoredProc in the NCOCI8 functions well, but if I execute same procedure for the AnyDac 1.x the error message "PL/SQL index for PL/SQL table out of range for host language array" I appear. Below they follow the params that I am using.
NCOCI8
ArrayLen = 10000
DataType = ftMemo
isCaseSensitive = False
IsNull = True
isPLSQLTable = True
Name = PI_GROUPIDNUMBER
ODataSize = 300
ODataType = otLong
OName = :PI_GROUPIDNUMBER
OParamType = odOut
ParamType = ptOutput
|
AnyDAC 1.x
ADDataType = dtAnsiString
ArraSize = 10000
ArrayType = atPLSQLTable
DataType = ftString
IsCaseSensitive = False
Name = PI_GROUPIDNUMBER
NumericScale = 0
ParamType = ptOutput
Position = 0
Precision = 0
Size = 300
|
My Procedure in Oracle 10G
TYPE gt_grplist IS TABLE OF VARCHAR2(300) INDEX BY BINARY_INTEGER;
...
PROCEDURE getGroupAllEntities(pi_groupidnumber OUT gt_grplist) IS
...
|
Best Regards,
Christian Balz
Post edited by: christian, at: 2008/03/26 14:29
|
|
