Calling unix script from sql or plsql

UNIX for Advanced & Expert Users
1

Hi

   Can anyone please let me know how to call unix scripts from sql or plsql ASAP.
2

A way to sovle the problem is external procedure.

you can write a c function to run shell script, it should be linked and warpped in a shared object(.so or .sl etc). And then create a procedure in oracle by calling this c function.

after that, you can use the procedure like other oracle build-in functions .

3

the sqlplus HOST command will run an OS command or script

HOST /path/to/myscript arg1 arg2