Hi,
I am trying to call an external procedure (C language dll) from PL/SQL but I get the following error:
ORA-28575: unable to open RPC connection to external procedure agent
I have read a lot about thie resloution of this problem by configuring tnsnames and listner properly. But the error remains the same. Following are my configuration info:
********* tnsnames.ora entry ***********
extproc_connection_data=
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = DLLTEST)
)
(CONNECT_DATA = (SID = extproc)
)
)
******************************************
*************Listner.ora *************
LISTENER=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC)(KEY=DLLTEST))
(ADDRESS=(PROTOCOL=TCP)(Host=mycomp)(PORT=1521))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=dlltest)
(ORACLE_HOME=C:\Oracle\Ora81)
(SID_NAME=dlltest)
)
(SID_DESC=
(SID_NAME=extproc)
(ORACLE_HOME=C:\Oracle\Ora81)
(PROGRAM=extproc)
)
)
STARTUP_WAIT_TIME_LISTENER=0
CONNECT_TIMEOUT_LISTENER = 10
********************************************
*********************** Lsnrctl Status ***********
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DLLTEST))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 -
tion
Start Date 18-JUL-2003 18:05:44
Uptime 0 days 0 hr. 34 min. 47 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:\oracle\ora81\network\admin\listener.ora
Listener Log File C:\oracle\ora81\network\log\listener.log
Services Summary...
DLLTEST has 1 service handler(s)
dlltest has 1 service handler(s)
extproc has 1 service handler(s)
**************************************************
tnsping also returns successful result.
I have tried the demo application in the
\ORA81\RDBMS\extproc as well but same results
Everything seems to be on track as experts have mentioned on web. but I think I still miss something.
Looking for ur help.
regards,
Asif
I am trying to call an external procedure (C language dll) from PL/SQL but I get the following error:
ORA-28575: unable to open RPC connection to external procedure agent
I have read a lot about thie resloution of this problem by configuring tnsnames and listner properly. But the error remains the same. Following are my configuration info:
********* tnsnames.ora entry ***********
extproc_connection_data=
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = DLLTEST)
)
(CONNECT_DATA = (SID = extproc)
)
)
******************************************
*************Listner.ora *************
LISTENER=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC)(KEY=DLLTEST))
(ADDRESS=(PROTOCOL=TCP)(Host=mycomp)(PORT=1521))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=dlltest)
(ORACLE_HOME=C:\Oracle\Ora81)
(SID_NAME=dlltest)
)
(SID_DESC=
(SID_NAME=extproc)
(ORACLE_HOME=C:\Oracle\Ora81)
(PROGRAM=extproc)
)
)
STARTUP_WAIT_TIME_LISTENER=0
CONNECT_TIMEOUT_LISTENER = 10
********************************************
*********************** Lsnrctl Status ***********
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DLLTEST))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 -
tion
Start Date 18-JUL-2003 18:05:44
Uptime 0 days 0 hr. 34 min. 47 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:\oracle\ora81\network\admin\listener.ora
Listener Log File C:\oracle\ora81\network\log\listener.log
Services Summary...
DLLTEST has 1 service handler(s)
dlltest has 1 service handler(s)
extproc has 1 service handler(s)
**************************************************
tnsping also returns successful result.
I have tried the demo application in the
\ORA81\RDBMS\extproc as well but same results

Everything seems to be on track as experts have mentioned on web. but I think I still miss something.
Looking for ur help.
regards,
Asif