Re: ORA-06513

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 do not use index values less than 1.

HopeThatHelps

"magar" <magarNOmaSPAM_at_ixl.com.invalid> wrote in message news:0a9c7c64.0521819a_at_usw-ex0109-069.remarq.com...
> All,
>
> We are having a problem with PL/SQL tables.
>
> When we run a simple procedure we get and ORA-06513.
>
> Does anybody know how to fix this?
>
>
> Thanks,
>
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful Received on Mon Jun 05 2000 - 00:00:00 CEST