Re: ORA-06502: PL/SQL

sikyala_at_comcast.net wrote:
>
> when I ran this script I receive the following error:ORA-06502: PL/SQL
> How do I fix this? Please help me someone.
>
> Thanks!
>

1. You look at the complete error message. Cutting at the error number is useless.
2. You then go to http://tahiti.oracle.com and look of the error message. That'll give you the following:

ORA-06502 PL/SQL: numeric or value error string

     Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).      Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.

3) You then use your incredible debugging skills to follow the recommended action against the line indicated by the part of the error message you cut off

(Perhaps someone else would be willing to comment about the coding technique <g>) Received on Tue Dec 14 2004 - 09:53:37 CST