Re: PL/SQL DBMS_SQL.DEFINE_ARRAY

Depends on where you are fetching to,
but on a local system I found the array approach in 8.0 to be about 3 or 4 times as quick as the cursor approach.

There is a simple sample on my web-site

    developer tricks -> pl/sql arrays

if you want to run a few tests without
having to work out all the details of getting the code right.

--

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

Matt Houseman wrote in message <856452$tjc$1_at_nntp1.atl.mindspring.net>...
>All,
>
>Is it best to use array fetches via DBMS_SQL.DEFINE_ARRAY or define a
cursor
>and build the array by looping through one row at a time? I would
>appreciate responses based on actual benchmarks rather than out of the
>Oracle doc.
>
>TIA,
>Matt Houseman
>
>
>
Received on Sat Jan 08 2000 - 02:57:37 CST