Ora-00972

[bhattnirav]

Following error occured while insert statement executed from PL/SQL block. Total length of insert statement is 3550.



Input truncated to 2499 characters
Input is too long (> 2499 characters) - line ignored
Input truncated to 1 characters
ERROR:
ORA-00972: identifier is too long




I have checked lenght of name of trigger, columns, synonyms. all are less than 30 character.

[aspdba]

does your insert statement have any double quote?

[kris109]

Are you executing from sqlplus?

[bhattnirav]

I am using sqlplus and i have checked there is no doule quotes in
insert statement

[aspdba]

sql plus has command line length limit of 2500 chars.

[kris109]

Do it from a stored proc.