Re: How to run sql*ldr from pl/sql ?

In article <DHoMDB.9ny_at_cix.compulink.co.uk>, esha1_at_cix.compulink.co.uk says... I've asked an someone at Oracle how to run an executable program from a trigger (PL/SQL), and they tell me that it's not directly possible with the current release. What is possible is to use dbms_pipes to send a message to a watchdog process running in background. This background process could then (on receiving the piped message) fire off sqlldr. Alternatively, dbms_alert could send a signal to the waiting background process. dmbs_pipes and alerts are described in the application developers manual.

Regards

Keenan Teylouni

>
>>
>> Hi, I would like a pl/sql block to delete a certain amount of records
>> from a table and then invoke sql*ldr with passed parameters to load
 some
>> new data into the table. Is there any way of starting sqlldr in this
 way
>> ?
>>
>> Thanks in advance,
>>
>> Mike Ziemann
 

>>How about:
 

>>!sqlload oraid/passwd
 

>>(escaping to unix from the SQLPLUS script).
 

>>\louis
>
>It is possible to issue !sqlplus oraid/passwd from SQLPLUS but not from
>PL/SQL. it doesn't enable me to call sqlldr and then continue with
>execution of the PL/SQL block.
>I have many variables in hand, I would then like to run slqldr and then
>carry on with PL/SQL block and carry on using the variables. Is there
>some function which will allow me to make a system call to UNIX ?
>
>Mike Ziemann
Received on Fri Nov 24 1995 - 00:00:00 CET