This forum is currently locked. You can't register or post questions at this time. (read more)

COM-support

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Guest

COM-support

Postby Guest » Mon Nov 01, 2004 6:09 pm

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...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

RE: COM-support

Postby Tim... » Mon Nov 01, 2004 6:09 pm

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
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 3 guests