Re: literal string to long, Reformating query to work

What version of Oracle?
What tool set are you working in:sqlplus, pl/sql, pro*c, SQL statement via ODBC, java,...?

The solution(s) available depend on the above two questions.

One possibility is to use sqlldr which can reference an associated file that hold the clob data for each row in the input set.

You might want to allocate a temporay lob segment and concatenate you data into it from where you can then populate your table lob.

Look at the dbms_lob package.

HTH -- Mark D Powell -- Received on Wed Aug 03 2005 - 19:26:06 CDT