Re: Impossible to Call External procedure from PL/SQL

Many Thanks Mark

Now, with your recommandation, I have no problem to connect to the external procedure listener.
But, I still have a problem. When I try to use any C standard function (e.g. like strcpy, strlen, ...) in my
C test program, the PL/SQL procedure fails to call the C program. But if i suppress any reference to
standard functions my C program works well. It seems that the binary code of these functions are not included in the .so file I have after linking my C program (using "ld -b test.o -o test.so"). So, the PL/SQL fails. How can i create a share object including binary code of standard procedures ?
Or do I need to declare some C standard libraries in Oracle before using the related functions ? (Like "create library..." or ?).

Many thanks

Nicolas Bragard
nicolas.bragard_at_st-ingenierie.fr

• Message d'origine ----- De : mgumbs <mgumbsNOmgSPAM_at_hotmail.com.invalid> Groupes de discussion : comp.databases.oracle.tools Envoyé : mardi 11 avril 2000 11:45 Objet : Re: Impossible to Call External procedure from PL/SQL

> You probably havent got your tnsnames.ora, listener.ora in sync.
> Also, in your sqlnet.ora file, if your names.default_domain =
> world, your listener name has to end in ,world in your
> tnsnames.ora (e.g extproc_connection_data.world = ......).
>
> Also, ensure that your SID_NAMES names are consistent between
> the listener.ora and tnsnames.ora
>
> Oracle have a problem checklinst on this subject on MetaLink
>
> Mark
>
>
> In article <jeAI4.325$0F4.1340532_at_nnrp2.proxad.net>, "Nicolas
> Bragard" <nicolas.bragard_at_st-ingenierie.fr> wrote:
> >When I try to call an external procedure (written in c
> Language), I have the
> >following message :
> >Ora-28575 : Unable to open RPC connection to external procedure
> agent.
> >
> >I run Oracle 8.1.5 on HP-UX 11. I have the listener for
> external procedure
> >(PLSExtProc) in my listener.ora and tnsnames.ora files. I check
> that this
> >listener correctly start.
> >
> >My c program compiles well and i have no error when creating
> the library in
> >oracle. My PL/SQL procedure compiles well. I have this message
> when I try to
> >run my PL/SQL procedure.
> >
> >Anyone got an idea ?
> >
> >Many thanks
> >
> >
> >
> >
> >
> >Nicolas BRAGARD
> >
> >nicolas.bragard_at_st-ingenierie.fr
> >
> >
> >
> >
> >
> >
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Wed Apr 12 2000 - 00:36:27 CEST