Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> URGENT:Calling COM components from PL/SQL
We were basically trying to call COM components from PL/SQL
We performed the following steps:
D:\>SVRMGRL
SVRMGR>connect INTERNAL/ORACLE; SVRMGR>GRANT create library TO SCOTT; SVRMGR>CONNECT SCOTT/TIGER; SVRMGR>@D:\ORACLE\ORA81\COM\COMWRAP.SQL
Then we tried the following piece of PL/SQL:
DECLARE
x BINARY_INTEGER;
y BINARY_INTEGER;
BEGIN
x:=ORCOM.CreateObject('Excel.Application',0,'',y);
END;
We are getting the following error
ORA-28575: Error Message
ORA-28575: unable to open RPC connection to external procedure agent
When we consulted the Oracle 8i documentation, it gave two possible reasons for the error.
1.either TNSNAMES.ORA is not properly configured or 2.Listener service is not started.
But we verified and found that either of the above cases isn't an issue. For
your reference,
we also reproduce our TNSNAMES.ORA and LISTENER.ORA files as attachments
with this posting.
Please help us in overcoming this error.
Other relevant details are as below:
Configuration of our computer:-
64Mb RAM, Celeron 333 Mhz Windows NT Server 4.0 SP4
Our Oracle configuration
Oracle8i Release 8.1.5.0.0 - Production PL/SQL Release 8.1.5.0.0 - Production CORE Version 8.1.5.0.0 - Production
Can somebody help us out ?
-VMK
begin 666 tnsnames.ora
M(R!$.EQ/4D%#3$5<3U)!.#%<3D545T]22UQ!1$U)3EQ43E-.04U%4RY/4D$@
M0V]N9FEG=7)A=&EO;B!&:6QE.D0Z7$]R86-L95Q/<F$X,5QN971W;W)K7&%D
M;6EN7'1N<VYA;65S+F]R80T*(R!'96YE<F%T960_at_8GD@3W)A8VQE($YE=#@@
M07-S:7-T86YT#0H-"D585%!23T-?0T].3D5#5$E/3E]$051!+D)34TP@/0T*
M(" H1$530U))4%1)3TX@/0T*(" @("A!1$1215-37TQ)4U0@/0T*(" @(" @
M*$%$1%)%4U,@/2 H4%)/5$]#3TP@/2!)4$,I*$M%62 ]($585%!23T,P*2D-
M"B @(" I#0H@(" @*$-/3DY%0U1?1$%402 ]#0H@(" @(" H4TE$(#T_at_4$Q3
M17AT4')O8RD-"B @(" @("A04D5314Y4051)3TX@/2!23RD-"B @(" I#0H@
M("D-"@T*0E-33" ]#0H@("A$15-#4DE05$E/3B ]#0H@(" @*$%$1%)%4U-? M3$E35" ]#0H@(" @(" H041$4D534R ]("A04D]43T-/3" ](%1#4"DH2$]3 M5" ]('9M:RDH4$]25" ](#$U,C$I*0T*(" @("D-"B @(" H0T].3D5#5%]$M051!(#T-"B @(" @("A315)624-%7TY!344@/2!"4U-,*0T*(" @("D-"B @ %*0T*#0H`
begin 666 listener.ora
M(R!$.EQ/4D%#3$5<3U)!.#%<3D545T]22UQ!1$U)3EQ,25-414Y%4BY/4D$@
M0V]N9FEG=7)A=&EO;B!&:6QE.D0Z7$]R86-L95Q/<F$X,5QN971W;W)K7&%D
M;6EN7&QI<W1E;F5R+F]R80T*(R!'96YE<F%T960_at_8GD@3W)A8VQE($YE=#@@ M07-S:7-T86YT#0H-"@T*97AT<')O8U]C;VYN96-T:6]N7V1A=&$N=V]R;&0@ M/0T*(" H1$530U))4%1)3TX@/0T*(" @("A!1$1215-3(#T-"B @(" @(" @M*%!23U1/0T],/4E00RD-"B @(" @(" @*$M%63U%6%104D]#,"D-"B @(" I M#0H@(" @*$-/3DY%0U1?1$%402 ]("A3240]97AT<')O8RD-"B @(" I#0H@
M("D-"@T*#0H-"DQ)4U1%3D52(#T-"B @*$1%4T-225!424].7TQ)4U0@/0T* M(" @("A$15-#4DE05$E/3B ]#0H@(" @(" H041$4D534U],25-4(#T-"B @ M(" @(" @*$%$1%)%4U,@/2 H4%)/5$]#3TP@/2!)4$,I*$M%62 ]($585%!2 M3T,P*2D-"B @(" @("D-"B @(" @("A!1$1215-37TQ)4U0@/0T*(" @(" @ M(" H041$4D534R ]("A04D]43T-/3" ](%1#4"DH2$]35" ]('9M:RDH4$]2 M5" ](#$U,C$I*0T*(" @(" @*0T*(" @("D-"B @*0T*#0I3241?3$E35%],M25-414Y%4B ]#0H@("A3241?3$E35" ]#0H@(" @*%-)1%]$15-#(#T-"B @ M(" @("A3241?3D%-12 ](%!,4T5X=%!R;V,I#0H@(" @(" H3U)!0TQ%7TA/ M344@/2!$.EQ/<F%C;&5<3W)A.#$I#0H@(" @(" H4%)/1U)!32 ](&5X='!R M;V,I#0H@(" @*0T*(" @("A3241?1$530R ]#0H@(" @(" H1TQ/0D%,7T1" M3D%-12 ]($]204-,12D-"B @(" @("A/4D%#3$5?2$]-12 ]($0Z7$]R86-L M95Q/<F$X,2D-"B @(" @("A3241?3D%-12 ]($]204-,12D-"B @(" I#0H@
M(" @*%-)1%]$15-#(#T-"B @(" @("A'3$]"04Q?1$).04U%(#T_at_0E-33"D- M"B @(" @("A/4D%#3$5?2$]-12 ]($0Z7$]R86-L95Q/<F$X,2D-"B @(" @ B("A3241?3D%-12 ]($)34TPI#0H@(" @*0T*(" I#0H-"@``