1 Reply Latest reply: Oct 3, 2012 10:34 AM by rp0428 RSS

    ORA-28575: unable to open RPC connection to external procedure

    538906
      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.