Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01438 (10g , XP SP2)
icon10.gif  ORA-01438 [message #328700] Sat, 21 June 2008 17:07 Go to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

I made that table :-
CREATE TABLE wired_table ( name VARCHAR2(9) , num NUMBER(2,2));

and when I tried to insert into the table by the usually way , the transaction failed !!!!!

I insert like that :-

SQL> insert into wired_table values ( 'Hany' , 22 );
insert into wired_table values ( 'Hany' , 22 )
                                          *
ERROR at line 1:
ORA-01438: value larger than specified precision allowed for this column


SQL> insert into wired_table values ( 'Hany' , 22.2);
insert into wired_table values ( 'Hany' , 22.2)
                                          *
ERROR at line 1:
ORA-01438: value larger than specified precision allowed for this column


SQL> insert into wired_table values ( 'Hany' , 22.53);
insert into wired_table values ( 'Hany' , 22.53)
                                          *
ERROR at line 1:
ORA-01438: value larger than specified precision allowed for this column


I really not understand what's went wrong in my insert statements ?!!!!!!
Re: ORA-01438 [message #328701 is a reply to message #328700] Sat, 21 June 2008 17:19 Go to previous message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
You have an error & you are incapable or unwilling to actual read about the datatype under discussion in the Fine SQL Reference Manual.

So which is your problem; incapable or unwilling?

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#sthref81

>I really not understand what's went wrong in my insert statements ?!!!!!!
What is wrong with your INSERT is:
ORA-01438: value larger than specified precision allowed for this column

What is the range of numeric values that can be held in num NUMBER(2,2)) & why the limit?

[Updated on: Sat, 21 June 2008 17:20] by Moderator

Report message to a moderator

Previous Topic: String Literal Required
Next Topic: Rewrite this query
Goto Forum:
  


Current Time: Tue Dec 06 04:12:53 CST 2016

Total time taken to generate the page: 0.12828 seconds