I get ORA-01401 error, my friend does not
I created a table and procedure. When I run it I get the ORA-01401 error. My friend who has Oracle 10g on Windows XP runs the procedure and does not get any error -- why?
create table test1 ( x char(2));then created a procedure:
create or replace PROCEDURE STATISTIC_test(X_T char) AS BEGIN INSERT INTO TEST1( X ) VALUES ( X_T ); END STATISTIC_test;When I run it it gives me this error:
ORA-01401: inserted value too large for column ORA-06512: at "ITVUSER.STATISTIC_TEST", line 4 ORA-06512: at line 6 Process exited.whereas my friend who has Oracle 10g on Windows XP runs the procedure and does not get any error -- why?
Dig Deeper on Oracle stored procedures
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments