Re: OS-command from within PL/SQL
From: Robert Marz <Robert.Marz_at_dlh.de>
Date: 1998/02/18
Message-ID: <6cfifg$41n_at_ar4dec01.ar4.fra.dlh.de>#1/1
Date: 1998/02/18
Message-ID: <6cfifg$41n_at_ar4dec01.ar4.fra.dlh.de>#1/1
>Is it possible to execute an OS (UNIX)-command from within a stored
>procedure ?
[Quoted] Oracle 8: yes. There is a new listener (I didn't tried yet) Oracle 7: implement it yourself.
Use the dbms_alert Package.
Write a little program which logs into the DB, registers itself to be
alerted and falls asleep. Whenever you want to exectute a command on the
system, signal the session of your program that there is something to do.
Let your Program spawn a process (system-call in C) and execute the command.
Depending on what you want to do you can use Queue-Tables and everything you
want...
For more Information see Application Developers Guide: Signalling Events in the Database
HTH
Bob
Received on Wed Feb 18 1998 - 00:00:00 CET