Re: Can't call external C procedure from oracle

From: Dale Edgar <Dale_at_DataBee.com>
Date: Sat, 11 Jan 2003 08:01:32 +0000 (UTC)
Message-ID: <3e1fcecb.4996534@news.btclick.com>

Hi Fez

The link below points to a really good article on creating and setting up external procedures. There is a discussion in there of how to set up the listener.ora file.

http://home.clara.net/dwotton/dba/oracle_extn_rtn.htm

Regards
Dale

Got big databases? Need test, dev and training databases? Use DataBee to create small referentially correct subsets of large production DB's DataBee: http://www.DataBee.com

On Fri, 10 Jan 2003 15:33:30 -0000, "Fez Panwaskar" <panwaskarf_at_logica.com> wrote:

>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0064_01C2B8BD.A0D0BF80
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>I'm trying to set-up a simple c dll external procedure call as described =
>in the oracle=20
>documentation. But I recieve the following error message:
>
>ORA-28575: unable to open RPC connection to external procedure agent
>ORA-06512: at "PDADMIN.SQ", line 0
>ORA-06512: at line 4
>
>I All suggestions point the error being related to the Listener.ora file =
>set-up and=20
>yet I have followed the example instruction to the letter.
>Has anyone come across this error?
>
>Here is the update to the Listener file:
>SID_LIST_LISTENER =3D
>(SID_LIST =3D
>(SID_DESC =3D
>(SID_NAME =3D extproc)
>(ORACLE_HOME =3D d:\oracle\ora81)
>(PROGRAM =3D d:\oracle\ora81\bin\<filename>)
>)
>)
>
>And the tnsnames:
>extproc_connection_data.<domain name> =3D
>(DESCRIPTION =3D
>(ADDRESS_LIST =3D
>(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D /* Hostname */)(PORT =3D 1521))
>)
>(CONNECT_DATA =3D
>(SID =3D extproc)
>)
>)
>
>I've then created a library and a function calling the external =
>procedure. But=20
>on calling the procedure I recieve the above mentioned error message.
>
>Under 'tnsping' I cannot ping the extproc_connection_data.<domain name> =
>the name cannot be resolved.
>
>If anyone has come across this problem can you please advise?
>Regards,
>
>Fez Panwaskar
>Space & Defence Division
>
>Logica
>
>Tel: +44 (0)137 27 59100
>
>Fax: +44 (0)137 27 59133
>
>panwaskarf_at_logica.com
>
><http://www.logica.com/>
>
>
>
>------=_NextPart_000_0064_01C2B8BD.A0D0BF80
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML><HEAD>
><META http-equiv=3DContent-Type content=3D"text/html; =
>charset=3Diso-8859-1">
><META content=3D"MSHTML 6.00.2800.1126" name=3DGENERATOR>
><STYLE></STYLE>
></HEAD>
><BODY bgColor=3D#ffffff>
><DIV>
><DIV>I'm trying to set-up a simple c dll external procedure call as =
>described in=20
>the oracle <BR>documentation. But I recieve the following error =
>message:</DIV>
><DIV><FONT face=3DArial size=3D2></FONT><BR>ORA-28575: unable to open =
>RPC connection=20
>to external procedure agent<BR>ORA-06512: at "PDADMIN.SQ", line =
>0<BR>ORA-06512:=20
>at line 4</DIV>
><DIV><FONT face=3DArial size=3D2></FONT><BR>I All suggestions point the =
>error being=20
>related to the Listener.ora file set-up and </DIV>
><DIV>yet I have followed the example instruction to the letter.<BR>Has =
>anyone=20
>come across this error?</DIV><FONT face=3DArial size=3D2></FONT><FONT =
>face=3DArial=20
>size=3D2></FONT>
><DIV><FONT face=3DArial size=3D2></FONT><BR>Here is the update to the =
>Listener=20
>file:<BR>SID_LIST_LISTENER =3D<BR>(SID_LIST =3D<BR>(SID_DESC =
>=3D<BR>(SID_NAME =3D=20
>extproc)<BR>(ORACLE_HOME =3D d:\oracle\ora81)<BR>(PROGRAM =3D=20
>d:\oracle\ora81\bin\<filename>)<BR>)<BR>)</DIV>
><DIV><FONT face=3DArial size=3D2></FONT><BR>And the=20
>tnsnames:<BR>extproc_connection_data.<domain =
>name> =3D<BR>(DESCRIPTION=20
>=3D<BR>(ADDRESS_LIST =3D<BR>(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D /* =
>Hostname */)(PORT=20
>=3D 1521))<BR>)<BR>(CONNECT_DATA =3D<BR>(SID =3D =
>extproc)<BR>)<BR>)</DIV>
><DIV><FONT face=3DArial size=3D2></FONT><BR>I've then created a library =
>and a=20
>function calling the external procedure. But <BR>on calling the =
>procedure I=20
>recieve the above mentioned error message.</DIV>
><DIV><FONT face=3DArial size=3D2></FONT> </DIV>
><DIV><FONT face=3DArial size=3D2>Under 'tnsping' I cannot ping the=20
>extproc_connection_data.<domain name> the name cannot be=20
>resolved.</FONT></DIV>
><DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial =
>size=3D2></FONT><FONT=20
>face=3DArial size=3D2></FONT><BR>If anyone has come across this =
>problem can you=20
>please advise?<BR>Regards,<BR></DIV>
><DIV>Fez Panwaskar</DIV>
><DIV><FONT color=3D#0000ff size=3D2>
><P>Space & Defence Division</P>
><P>Logica</P>
><P>Tel: +44 (0)137 27 59100</P>
><P>Fax: +44 (0)137 27 59133</P>
><P>panwaskarf_at_logica.com</P><U>
><P><http://www.logica.com/></P></U></FONT><FONT face=3DArial =
>size=3D2>
><P> </P></FONT></DIV></DIV></BODY></HTML>
>
>------=_NextPart_000_0064_01C2B8BD.A0D0BF80--
>
Received on Sat Jan 11 2003 - 02:01:32 CST