SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

538906Oct 3 2012 — edited Oct 3 2012

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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2012

Added on Oct 3 2012

#sql-developer

1 comment

133 views