URGENT:Calling COM components from PL/SQL
Date: Thu, 11 Nov 1999 17:05:57 +0530
Message-ID: <80ff4n$oeq$1_at_news.vsnl.net.in>
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>_at_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
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production NLSRTL Version 3.4.0.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$_at_
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_at_3W)A8VQE($YE=#@@
M07-S:7-T86YT#0H-"D585%!23T-?0T].3D5#5$E/3E]$051!+D)34TP_at_/0T*
M(" H1$530U))4%1)3TX_at_/0T*(" @("A!1$1215-37TQ)4U0@/0T*(" @(" @
M*$%$1%)%4U,_at_/2 H4%)/5$]#3TP@/2!)4$,I*$M%62 ]($585%!23T,P*2DM"
B _at_(" I#0H@(" @*$-/3DY%0U1?1$%402 ]#0H@(" @(" H4TE$(#T_at_4$Q3
M17AT4')O8RD-"B _at_(" @("A04D5314Y4051)3TX@/2!23RD-"B @(" I#0H@
M("D-"_at_T*0E-33" ]#0H@("A$15-#4DE05$E/3B ]#0H@(" @*$%$1%)%4U-? M3$E35" ]#0H_at_(" @(" H041$4D534R ]("A04D]43T-/3" ](%1#4"DH2$]3 M5" ]('9M:RDH4$]25" ](#$U,C$I*0T*(" _at_("D-"B @(" H0T].3D5#5%]$M051!(#T-"B _at_(" @("A315)624-%7TY!344@/2!"4U-,*0T*(" @("D-"B @ %*0T*#0H`
`
end
begin 666 listener.ora
M(R!$.EQ/4D%#3$5<3U)!.#%<3D545T]22UQ!1$U)3EQ,25-414Y%4BY/4D$_at_
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_at_3W)A8VQE($YE=#@@ M07-S:7-T86YT#0H-"_at_T*97AT<')O8U]C;VYN96-T:6]N7V1A=&$N=V]R;&0@ M/0T*(" H1$530U))4%1)3TX_at_/0T*(" @("A!1$1215-3(#T-"B @(" @(" @M*%!23U1/0T],/4E00RD-"B _at_(" @(" @*$M%63U%6%104D]#,"D-"B @(" I M#0H_at_(" @*$-/3DY%0U1?1$%402 ]("A3240]97AT<')O8RD-"B @(" I#0H@
M("D-"_at_T*#0H-"DQ)4U1%3D52(#T-"B @*$1%4T-225!424].7TQ)4U0@/0T* M(" _at_("A$15-#4DE05$E/3B ]#0H@(" @(" H041$4D534U],25-4(#T-"B @ M(" _at_(" @*$%$1%)%4U,@/2 H4%)/5$]#3TP@/2!)4$,I*$M%62 ]($585%!2M3T,P*2D-"B _at_(" @("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*(" _at_(" @*0T*(" @("D-"B @*0T*#0I3241?3$E35%], M25-414Y%4B ]#0H_at_("A3241?3$E35" ]#0H@(" @*%-)1%]$15-#(#T-"B @ M(" _at_("A3241?3D%-12 ](%!,4T5X=%!R;V,I#0H@(" @(" H3U)!0TQ%7TA/M344_at_/2!$.EQ/<F%C;&5<3W)A.#$I#0H@(" @(" H4%)/1U)!32 ](&5X='!R
M;V,I#0H_at_(" @*0T*(" @("A3241?1$530R ]#0H@(" @(" H1TQ/0D%,7T1" M3D%-12 ]($]204-,12D-"B _at_(" @("A/4D%#3$5?2$]-12 ]($0Z7$]R86-L M95Q/<F$X,2D-"B _at_(" @("A3241?3D%-12 ]($]204-,12D-"B @(" I#0H@ M(" _at_*%-)1%]$15-#(#T-"B @(" @("A'3$]"04Q?1$).04U%(#T_at_0E-33"D-M"B _at_(" @("A/4D%#3$5?2$]-12 ]($0Z7$]R86-L95Q/<F$X,2D-"B @(" @ B("A3241?3D%-12 ]($)34TPI#0H_at_(" @*0T*(" I#0H-"@``
`
end Received on Thu Nov 11 1999 - 12:35:57 CET