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?