This content has been marked as final. Show 3 replies
I'd welcome alternatives, as well. I just require being able to create tables, insert data (with varchar2's up to 4000 characters) from a script run on Solaris, Linux and Windows. SQL*Plus almost works if I can figure a way to make it accept really long strings.
richip wrote:You might need to find another "insert" method - SQL*Loader or an external table instead
I've checked out the previous threads regarding this issue and none seem to address the problem I have. My problem is that I have a literal string that is itself > 2499 characters. How would I use SQL*Plus and a script to INSERT a row containing a VARCHAR2 (which has a limit of 4000 bytes) that is > 2499 characters? If I need to break it up, how does one break a line of string? Escape the linefeed somehow?
The solution I ended up using was to break down the long string literal into smaller (< 2500 characters) fragments and just use the concatenation operator (||).
Now if only there was a way to make Toad spit out SQL INSERT statements that break down strings like this.