Re: Impossible to Call External procedure from PL/SQL

From: mgumbs <mgumbsNOmgSPAM_at_hotmail.com.invalid>
Date: Tue, 11 Apr 2000 02:45:29 -0700
Message-ID: <14eb9333.895c8709_at_usw-ex0106-047.remarq.com>


[Quoted] 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 * [Quoted] The fastest and easiest way to search and participate in Usenet - Free!
Received on Tue Apr 11 2000 - 11:45:29 CEST

Original text of this message