Ora-28595 EXTPROC
Hi
anyone know how to configure 10.1.0.4 Database to talk with an external procedure in an C DLL under Windows Server 2000.
If I configure Listener
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <HOST>)(PORT = 1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))
)
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(ORACLE_HOME=c:\oracle\product\10.1.0\Db_1)
(SID_NAME=<SID>))
(SID_DESC=
(SID_NAME=plsextproc)
(ORACLE_HOME=c:\oracle\product\10.1.0\Db_1)
(PROGRAM=extproc)))
TNSNAMEs.ora
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
STREDAXE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <host>)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = <SID>)
)
)
EXTPROC_CONNECTION_DATA=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))
(CONNECT_DATA=
(SID=plsextproc)))
following error is writen in the trace file
# Oracle Corporation --- TUESDAY JUL 18 2006 11:42:58.718
# Heterogeneous Agent Release
# 10.1.0.4.0
# Failed to load Extproc Library : c:\oracle\product\10.1.0\Db_1\BIN\fcit_oraext.dll
# Oracle Error : ORA-28595 :
# Request originating from address : (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NTN_11DC_D9B39FC9.ORA))
Library entry:
create or replace library FCIT_LIB as 'c:\oracle\product\10.1.0\Db_1\BIN\fcit_oraext.dll'
procedure which call the DLL:
CREATE OR REPLACE FUNCTION NET_SEND(
recipient IN VARCHAR2,
message IN VARCHAR2)
RETURN BINARY_INTEGER AS
EXTERNAL LIBRARY FCIT_LIB
NAME "SendNetMessage" -- Name of function call. Quotes preserve lower case.
LANGUAGE C
PARAMETERS (
recipient STRING,
message STRING,
RETURN INDICATOR short);
Filemon shows that there is no try to read the DLL file.
Did anyone have an hint where to look for the solution.
Under 8i everything
- PL/SQL-procedure and
- DLL
are working fine.
Hints are welcome.
Thorsten Fischer