Shell script call from a DB trigger

Shell Programming and Scripting
1

Has anybody been able to execute a shell script call from a database trigger?

If so what are the steps to execute it? Do we have any specific packages in Oracle?

Reards,
Rahul.

2

There is no specific packages available in Oracle 9i to execute any shell script or shell commands. But you can use external procedures like java or C to call the shell script.Please refer the below site for more details.

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:952229840241

There is also a new method in Oracle 10G, where you can use the DBMS_SCHEDULER package to run a host executable.