COM-support

[Guest]

Im installing COM-support to my Oracle8i server.
Its code:

declare
v_test char(20);
hresult binary_integer;
applicationToken binary_integer:=-1;

begin
hresult :=ORDCOM.CreateObject('WScript.Shell', 0, '', applicationToken);
IF hresult = -1 THEN
dbms_output.put_line(hresult);
END IF;

end;
/

Error:
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "CREATOR.OACREATE", line 0
ORA-06512: at "CREATOR.ORDCOM", line 263
ORA-06512: at line 8

Service OracleOraHome81TNSListener running.

May be problem in Listener or TNSNames.
Listener:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.144.5)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)


STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM = extproc)
)
(SID_DESC =
(global_dbname = work)
(ORACLE_HOME = d:\Oracle\Ora81)
(SID_NAME = WORK)
)
)

TNSNames:
B2TEST.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.144.5)(PORT = 1521))
)
(CONNECT_DATA = (service_name = WORK)
)
)

EXTPROC_CONNECTION_DATA.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(CONNECT_DATA = (SID = extproc))
)


TCP-LOOPBACK.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(CONNECT_DATA = (SID = WORK))
)

Please help.

[Tim...]

The only difference I can see between your settings and mine is that my SID for extproc is PLSExtProc.

I would suggest having a look through this:

http://otn.oracle.com/docs/products/ora ... .htm#10884