How Do You Call Unix Shell Script from Oracle Pl Sql?

How do you call a shell script from PL SQL?

Execute a shell script from a PL/SQL procedure

1. You can execute UNIX commands from inside Oracle by using the EXTPROC functionality.
2. You can define an external routine and use the dbms_pipe package to call a UNIX shell script.
3. Here is an example of a invoking a shell script from PL/SQL using dbms_scheduler:

How do I run a shell script in Oracle?

Running a shell script from inside an Oracle database using DBMS_SCHEDULER

1. create an OS user on the database server.
2. create an OS group to allow both the new user and the oracle user to access to a common location.
3. create a shell script owned by the OS user which writes to that common location.