Executing shell script from PLSQL

Hi All,

I have a requirement to mv a file in unix from plsql procedure.
for that i have created a java host procedure, a host_command, given all grants as per ORACLE-BASE - Oracle8i Shell Commands From PL/SQL

but i am getting an error ""Process err :/bin/sh: mv Not Found""

kindly let me know what to do
.
Thanks
Aryan

The only way I know to do what you want in 8i is to write an external C program (OCI)
with a system() call, put it in an external library, and attach it to oracle with tsnlsnr.