SP2-0027 Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SP2-0027 Error

Hybrid View

  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
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Sqlplus is probably interpreting the script as one line, make sure you have proper line breaks in the file.

    Check the file in notepad (or something similar)

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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