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.
This forum is for sql developer questions only.
Since this is not a SQL Developer question it should be posted in the SQL and PL/SQL forum SQL and PL/SQL
Please mark this question ANSWERED and repost it in the other forum.