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"
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)
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!
Click Here to Expand Forum to Full Width