-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|