Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Fetch array in PL/SQL

Fetch array in PL/SQL

From: <alex_n_at_equinoxlt.com>
Date: Thu, 06 Aug 1998 17:02:06 GMT
Message-ID: <6qcnie$uct$1@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 Thu Aug 06 1998 - 12:02:06 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US