Re: multithreaded external procedure setup

To use multi threaded callouts on NT you need 8.0.4+ which includes the external agent service, a full description can be found in the Getting Started Guide 15-8. Also in your example each row will be passed into the external procedure, a row at a time.

Regards
David Russell

Lutz Magnus Feldhege wrote in message <35C1F12D.D2DDE892_at_de.uu.net>...
>Hi,
>
>we are using Oracle 8.0.3 on NT. We want to use external procedure to do
>some complex arithmetic. For a test we took an example and implemented a
>simple greater function based on two binary_integer's (plus all pragmas
>R/WNDS and R/WNPS). Then we created a table with a primary key integer
>field including values from 1 until 50000. The following query takes
>approx. 20 seconds until it returns the result:
>
>select * from testtable where testpkg.greater(id, 25000) > 0;
>
>Doing the following takes not even a second:
>
>select * from testtable where id > 25000;
>
>We found in the documentation that it is possible to use external
>functions also multithreaded, by setting ORA_EXTPROC_THREADED to TRUE.
>But we do not see any different behavior.
>
>Does anyone can give us a hint, what we are missing here.
>
>Thanks
>Lutz
Received on Sat Aug 01 1998 - 19:24:02 CDT