PL/SQL - ORA-06502 Error

[wellster34]

Hi,

I have a PL/SQL script and I keep getting the ORA-06502 error everytime I try to fetch my cursor.

I have looked at the description and I have gone over the code. I found nothing that appears to be causing the error.

Any ideas on how to debug this?

Thanks

 

[carp]

Please post the full error message.

 

[wellster34]

The error message is:

Sqlcode is -6502
Error Message is ORA-06502: PL/SQL: numeric or value error: character string buffer too small

After looking over this code for 2 hours... I finally found the error. I had a variable with a limit of char of 40 and I was assigning it a value greater than 40 characters long.

I feel stupid. I should of found that error earlier. The error message was not that descriptive of where the error occurred. Lesson learned on my part.

 

[ociruj]

Hi,

may i see ur script?

 

[carp]

This one happens a lot - the trick then becomes to figure out WHICH buffer is too small!