Posted on 2003-02-25
I need some advice on inserting CLOB data using SQL*Plus.
I have a table with a CLOB, and a sweries of insert statements containing CLOB data. These inserts were obtained from a MySQL data dump when migrating to Oracle. The CLOB data is long - at least 8000 characters.
When executing the insert I get an ORA-01704 error message, saying that my data is too long.
What's the easiest way to get this data into my table ?
I have checked other posts here, but can't find an answer.