Re: SQL INSERT FAILS - IDENTIFIER TOO LONG (ORA-00972)

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
>

--
http://www.freelists.org/webpage/oracle-l