Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |