Re: External Procedures under Oracle 8i Release 1

Interesting point, I have always assumed that the only sensible option would be to configure a separate listener because of different characteristic activity -

    Listening for connections could be for

1. multiple services
2. multiple protocols with a relatively low rate of calls

    Listening for extproc calls would be for

1. one service
2. one protocol with potentially a high rate of calls

Am I making an incorrect assumption about the way that connections to extproc are
maintained. If you have:

    select externalised_proc(col) from tablename;

do I make one connection per row, or
one connection for the entire query ?

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Sybrand Bakker wrote in message ...


>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

>

>