dump.sql

After dumping out several thousand records, I get:

>ERROR:
>ORA-01489: result of string concatenation is too long

without getting exhaustively exhaustive about the thing, anyone seen the error?

thanks,
ep

http://www.cybcon.com/~jkstill/util/dump/dump.html

Dump Tables To A Flat File

      Dump Oracle Tables To ASCII/Comma Delimited File  

dump.sql is a utility to dump a single table to a comma and double quote delimited file. In addition, SQL*LOADER control and parameter files will be generated as well.

dump.sql will remove all double quotes from the data to avoid confusing SQL*LOADER. If you don't like this behavior, you may easily modify dump.sql to use a different delimiter, or skip using the quotes altogether.

The use of the quotes however, makes it possible for commas to appear in the data without confusing SQL*LOADER.

dump.sql in ASCII
( http://www.cybcon.com/~jkstill/util/zips/dump.sql )

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: PierceED_at_csus.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).