Re: Can SQL *Loader parse data from a CLOB source rather than a file?

stan.zieg_at_sciatl.com (swz) wrote:
> I need to parse multiple files that are present on the database within
> CLOBs.
>
> I would like to parse them using SQL Loader, because I believe that it
> would be more efficient in loading the data.
>
> Is there a way to use the CLOB field as a source, rather than a file
> instance?

Under unix, you can make a named pipe and have SQL Loader use that as a source. Then you just need something to read the CLOB and write it to the named pipe.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB