471,306 Members | 839 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,306 software developers and data experts.

Errors ORA-06502 and ORA-01438

nabh4u
62
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.
Aug 7 '07 #1
3 5386
pjda
4
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.
Aug 27 '07 #2
debasisdas
8,127 Expert 4TB
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 .
Aug 28 '07 #3
amitpatel66
2,367 Expert 2GB
Increase the size of the variable that is trying to store the values larger thatn its size would solve your problem!!
Aug 28 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by mikey_boy | last post: by
2 posts views Thread by Trev | last post: by
10 posts views Thread by Douglas Buchanan | last post: by
24 posts views Thread by pat | last post: by
8 posts views Thread by ImOk | last post: by
2 posts views Thread by =?Utf-8?B?UmFuZHlz?= | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.