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

On May 10, 4:27 am, auu..._at_dsl.pipex.com wrote:
> Hi there,
>
> I know that this question has been posted a lot, but I've tried all of
> the various options for resolving the problem and none have worked. I
> have the following setup in the TNSNames:
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> and this in listener.ora:
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = ltbdbs01)(PORT = 1521))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\oracle\ora920)
> (ENVS="EXTPROC_DLLS=ANY")
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = LON_TFLP.WORLD)
> (ORACLE_HOME = D:\oracle\ora920)
> (SID_NAME = LON_TFLP)
> )
> )
>
> I restarted the listener service, and then I've created the library
> as:
>
> create or replace library rwnet as 'D:\Oracle\ora920\lib\RWnet.dll'
>
> built the extproc procedure as:
>
> CREATE PACKAGE RWNet_Package AS
> PROCEDURE Init (password IN char);
> END RWNet_Package;
> /
>
> CREATE PACKAGE BODY RWNet_Package AS
> PROCEDURE Init (password IN char) AS
> LANGUAGE C
> LIBRARY RWNet
> NAME "Init"
> PARAMETERS (password string);
> END RWNet_Package;
> /
>
> and created the final call package invoking the init procedure as:
>
> CREATE PACKAGE PTAI_RWNET AS
> Procedure Initialise (v_Password IN VARCHAR);
> END PTAI_RWNET;
> /
>
> and
>
> CREATE PACKAGE BODY PTAI_RWNET AS
> Procedure Initialise (v_Password IN VARCHAR) AS
> intReturn NUMBER;
> Begin
> RWNET_Package.Init(v_Password);
> End Initialise;
> END PTAI_RWNET;
> /
>
> After all this, I still get the RPC error when I try to run the
> Initialise procedure, can anyone let me know where I might be going
> wrong? Is it worth rebooting the server (as I've heard works) or is
> that just a waste of time?
>
> Cheers and TIA
>
> Dan

It would help tremendously were you to provide the Oracle release (to four numbers) that you are using.

David Fitzjarrell Received on Thu May 10 2007 - 07:47:24 CDT