Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Fetch array in PL/SQL
Hello Alex,
as far as I know there are no arrays in PL/SQL when work with Oracle 7. In
Oracle 8 there is some kind of array handling.
How about writing the results in a temporary table? Have you worked with
the PL/SQL cursors already? With a cursor you treat each single result in a
"loop until no more rows found".
Regards
Corinna
alex_n_at_equinoxlt.com wrote in article <6qcnie$uct$1_at_nnrp1.dejanews.com>...
> Hello all,
> I know that it is possible to fetch into an array of host variables when
using
> Pro*C, however in PL/SQL it looks like you can olny fetch one row at a
time.
> Does anyone know how to (if at all possible) fetch, say 100 rows at a
time,
> in a PL/SQL procedure.
>
> Thanks in advance
> Alex
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Wed Aug 12 1998 - 01:44:42 CDT
![]() |
![]() |