Oracle DBA, How To, Error, Cause and Action

ORA-06513: PL/SQL: index for PL/SQL table out of range for hostlanguage array

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




Cause: 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: Increase size of host language array, or decrease size of PL/SQL table. Also make sure that you don't use index values less than 1.