Re: SQL INSERT FAILS - IDENTIFIER TOO LONG (ORA-00972)
- From: Michael Twaddell <twaddell@xxxxxxxxxxxx>
- To: johan.muller@xxxxxxxxx
- Date: Fri, 22 Sep 2006 08:10:29 -0500
Johan,
I was able to get the following to work:
insert into test
values(1,1,1,1,1,1,'10.128.3.232',3,'false','false','none',1158784510000,
1,1158784510000,'NMS',27,1,1283,
'Unexpected event in current state',
'Backup failed : Please check /u02/backups/backups_26810.err for
errors',
5,null,null,null,null, 1);
Basically I just substituted a single quote for all double quotes and entered
the word null where you had no values entered.
Michael T.
Johan Muller wrote:
What is really causing the insert to fail? My object name is 4
characters long; max lenght is 30 characters. Oracle 10.2 on RHE rel 4.
This is from a back-end pl/sql process that is called by a perl script;
we are not getting any errors from perl or the log file.
Trying it manually does show the error though.
SQL> SQL> insert into test
values
(1,1,1,1,1,1,"10.128.3.232
<http://10.128.3.232>",3,"false","false","none",1158784510000,1,1158784510000,"NMS",27,1,1283,"Unexpected
event in current state","Backup failed : Please check
/u02/backups/backups_26810.err for errors",5,,,,,1);
2 3 (1,1,1,1,1,1,"10.128.3.232
<http://10.128.3.232>",3,"false","false","none",1158784510000,1,1158784510000,"NMS",27,1,1283,"Unexpected
event in current state","Backup failed : Please check
/u02/backups/backups_26810.err for errors",5,,,,,1)
*
ERROR at line 3:
ORA-00972: identifier is too long
--
Johan Muller
Oracle DBA
(214) 676 2147 anytime.
"Democracy is two wolves and a lamb voting on what to have for lunch.
Liberty is a well-armed lamb contesting the vote." --Benjamin Franklin
--
//www.freelists.org/webpage/oracle-l
Other related posts:
