Re: External Procedures under Oracle 8i Release 1

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 30 Sep 2000 08:23:06 +0200
Message-ID: <ph1btskvj704mmbv0mjs0kvgv0rn0enc6l@4ax.com>

On Thu, 28 Sep 2000 15:28:52 -0400, Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote:

>After wading through a virtual sea of information on the Oracle support
>site I have a couple questions on external procedures:
>
>1. Is it necessary/desireable to have a separate listener just for
>external procedures?
>

No, it should be sufficient to configure an existing listener for external procedures

>2. Is the value for "KEY=" arbirtary as long as it exactly matches
>between the tnsnames.ora and the listener.ora entries?
>

The convention is that the KEY either equals the SID or EXTPROC0

>3. I have seen a tnsnames.ora definition which includes the setting
>"(PRESENTATION = R0)" - What does this mean? Is it necessary?
>
>

Sqlnet in 8i supports both 'ordinary' and jdbc clients. The presentation=r0 line is referring to ordinary clients. I'm not sure what the default is.

Hth

Sybrand Bakker, Oracle DBA Received on Sat Sep 30 2000 - 01:23:06 CDT