Re: plsql error understanding

toby_moray <nospam_at_newsranger.com> wrote in message news:<u6np7.2792$p77.4857_at_www.newsranger.com>...
> Hi,
> I'm getting the following error when running PL/SQL through Oracle Portal:
>
> PL/SQL: numeric or value error: NULL index table key value
>
> Would anyone have any ideas as to possible causes for this (ie. what does it
> mean????)
>
> Many thanks.
>
> Toby

Generally this type of error occurs because of data type / data length mismatch. That is if in the declare section U have declared name varchar2(30)

and U have a record where the name is longer than 30 chars

Or if U declared
value number(5)

and U have a record where the VALUE is NOT AVAILABLE.

Check the data & the variables declared. Thanks
Sanjay Received on Wed Sep 26 2001 - 15:48:43 CEST