Home » RDBMS Server » Server Administration » Simple Insert throwing an error
Simple Insert throwing an error [message #63892] Mon, 22 November 2004 01:12 Go to next message
VJ
Messages: 24
Registered: June 2002
Junior Member
Hello , please look at the below scenario ...

desc sample
a number(6)
b char(1)
c varchar2(100)
d number(1)

INSERT INTO sample (a, b, c,d)
VALUES (9982,'1','sample text',0);

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01438: value larger than specified precision allows for this column

 

what is the issue .. ?

thanks in advance

-Vj

Report message to a moderator

Re: Simple Insert throwing an error [message #63897 is a reply to message #63892] Mon, 22 November 2004 04:25 Go to previous messageGo to next message
croK
Messages: 170
Registered: April 2002
Senior Member
I setup a test case, and runs ok.
oracle 9.2.0.1 on NT.

Report message to a moderator

Re: Simple Insert throwing an error [message #63900 is a reply to message #63892] Mon, 22 November 2004 04:37 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Must be some kind of trigger firing.
Which triggers are on the table (or higher level) ?

Report message to a moderator

Previous Topic: 64 Bit Oracle
Next Topic: sftp
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 15 04:50:10 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.