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)