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

> 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.

Isn't this like trying to pound a nail with a sledgehammer? Or as my great grandpappy used to say, "Why chase the mouse around the house when a trap and piece of cheese will do all the work?"

Why pull the data out of the database, run it through a pipe, feed the results into SQL*Loader and then use it to parse the data when SQL statements can do what you need? If there is a performance problem with the SQL statements, tune that.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"