Ora-00972
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Ora-00972

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249

    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.

  2. #2
    Join Date
    Aug 2002
    Posts
    115
    does your insert statement have any double quote?

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    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

  4. #4
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    I am using sqlplus and i have checked there is no doule quotes in
    insert statement

  5. #5
    Join Date
    Aug 2002
    Posts
    115
    sql plus has command line length limit of 2500 chars.

  6. #6
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    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
  •  



Click Here to Expand Forum to Full Width