Re: Stored Proc Can't call External Proc - Help!

Samuel.Bates_at_madison.nmt.com (Samuel Bates) wrote:

>SQLWKS> execute sam.delores;
>ORA-28575: unable to open RPC connection to external procedure agent
>ORA-06512: at "SAM.OPENTHEFILE", line 0
>ORA-06512: at "SAM.DELORES", line 4
>ORA-06512: at line 2

Have you modified tnsnames.ora and listener.ora to add references to the extproc process? What did you write your DLL in? I think Oracle8 currently only supports calls to procedures written in C. Java, C++, etc.. are supposedly on the way.

I got that error message before too. When I restarted Oracle, it went away. Go figure.

-Darren

Darren Mallette
www.geocities.com/HotSprings/7490 Received on Fri Sep 05 1997 - 00:00:00 CEST