DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SP2-0027

  1. #1
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

    Question

    Hello,

    I have sql file with many inserts in it for different tables.

    When I run this script using TOAD ( a tool for Oracle application Developers from Quest s/w) it works fine without a single error.

    But when I run this file in a SQL*Plus, I get error
    ***** SP2-0027: Input is too long (> 2499 characters) - line ignored *****

    and because of this many other insert statements fail giving FK error.

    How do I overcome this "SP2-0027"

    Thanks

    Sameer

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    It´s a limit in SQL*PLUS, from the manuals :

    "ORA-01704 string literal too long

    Cause: A quoted string specified as a constant was too long.

    Action: Quoted strings may not contain more than 2000
    characters."

    You must to break the string, something like :

    insert xxx values ('string < 2000 chars' || 'another piece of the string ' || 'another' ......


    Regards,

    Chiappa



  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    This is a duplicate of http://www.dbasupport.com/forums/sho...threadid=21146

    In the future, please post your question on only one forum.
    Jeff Hunter

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