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

> I can and have used PL/SQL to do similar parsing, but I have observed
> the parsing process to be slower than SQL*Loader, and these will be
> fairly large files. I figured SQL*Loader was probably optimized
> better than I could achieve by hand crafting my own code. Besides,
> I'd rather maintain and support just the SQL*Loader definitions rather
> than a chunk of PL/SQL code. But - given that SQL*Loader can't get
> the data from the file system, I don't have any choice!

I think you meant that SQL*Loader can't get the data directly from a table. It can get it from the a file in the file system. Anyway....

If you are having problems with your performance on your PL/SQL routine, then you might consider posting your issue here. Just like SQL statements, PL/SQL blocks can use some tuning too. I'm not quite sure how your are parsing or what you are trying to accomplish, but your PL/SQL routine may require some work. Or, have you considered if you can do this in straight SQL? As for maintaining the code, you can store the PL/SQL code in a flat file just like storing the SQL*Loader control file. The "maintenance" and "support" should be identical.

HTH,
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"