Oracle DB Error ORA-06513 PL/SQL: index for PL/SQL table out of range for host language array

The following is the cause of this error message:

An attempt is being made to copy a PL/SQL table to a host language array. But an index in the table is either less than one or greater than the maximum size of the host language array. When copying PL/SQL tables to host language arrays, the table entry at index 1 is placed in the first element of the array, the entry at index 2 is placed in the second element of the array, etc. If an table entry has not been assigned then the corresponding element in the host language array is set to null.

Action you can take to resolve this issue: Increase size of host language array, or decrease size of PL/SQL table. Also make sure that you do not use index values less than 1.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related