Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Call SQL-Loader from PL/SQL?

Re: Call SQL-Loader from PL/SQL?

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Fri, 30 Apr 2004 22:56:50 +0200
Message-ID: <k8f59051lm82v158ad0g6s8nd6ps79e5lv@4ax.com>


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 DBA
Received on Fri Apr 30 2004 - 15:56:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US