Errors ORA-06502 and ORA-01438

[nabh4u]

HI everyone,

I an getting the following errors when i execute my procedure.

SQL> exec PROCEDURE_NAME
BEGIN PROCEDURE_NAME; END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "PROCEDURE_NAME", line 164
ORA-01438: value larger than specified precision allows for this column
ORA-06512: at line 1

I am using oracle 9i and sqlplus to execute the procedure.

I even tried setting the serveroutput on and increasing the size to some 1000000. But i still get the same errors.

I dont understand what to do.

any help will be appreciated.

thanks in advance

nabh4u.

[pjda]

HI everyone,

I an getting the following errors when i execute my procedure.

SQL> exec PROCEDURE_NAME
BEGIN PROCEDURE_NAME; END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "PROCEDURE_NAME", line 164
ORA-01438: value larger than specified precision allows for this column
ORA-06512: at line 1

I am using oracle 9i and sqlplus to execute the procedure.

I even tried setting the serveroutput on and increasing the size to some 1000000. But i still get the same errors.

I dont understand what to do.

any help will be appreciated.

thanks in advance

nabh4u.

This doesn't sound like a SERVEROUTPUT issue. You would have to post Line 164 of procedure PROCEDURE_NAME, plus what you're trying to put into it before anyone could help you.

[debasisdas]

the error message clearly says the the error is becauss of error in the procedure body and the main reason is ,it is trying to assign a lave value to a variable of smaller precision.

like assigning 'SSSSSSSSSSSSSSSSSSSSSSSSSSSSSS' to a varchar2(10) variable .

[amitpatel66]

Increase the size of the variable that is trying to store the values larger thatn its size would solve your problem!!