SQL & PL/SQL

Hi All,

I am facing a problem "ORA-28575: unable to open RPC connection to external procedure agent." while calling an unix shell script from oracle procedure.

I checked extproc listener and other services , all are up and running .

one strange thing what i observed is if i execute script directly in sql editor like begin START_SHELL_MY('script.sh','prd',' '); end; then script gets executed

but if i schedule same thing using dbms_job package then i get this error.

Kindly help me