-
Ora-00972
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.
-
does your insert statement have any double quote?
-
Are you executing from sqlplus?
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
I am using sqlplus and i have checked there is no doule quotes in
insert statement
-
sql plus has command line length limit of 2500 chars.
-
Do it from a stored proc.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|