Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Call SQL-Loader from PL/SQL?
On Fri, 30 Apr 2004 11:12:33 +0200, FlameDance <flamedance_at_gmx.de>
wrote:
>Hi,
>
>there is no way to call an external batch or program from PL/SQL, I
>learned to my dismay.
>
>I want to use the SQL Loader and call it from PL/SQL - is there a
>package or function call that allows it?
>
>Yours, Stephan
It would be inefficient and also ridiculous to do that, as it would set up a second connection to your database, and second session, both sessions won't 'see' each other. Just write a batch script, and don't even think of trying to implement such crappy 'solutions'
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri Apr 30 2004 - 15:56:50 CDT