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"
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
You must to break the string, something like :
insert xxx values ('string < 2000 chars' || 'another piece of the string ' || 'another' ......
This is a duplicate of http://www.dbasupport.com/forums/sho...threadid=21146
In the future, please post your question on only one forum.
Click Here to Expand Forum to Full Width