fetch in PL/SQL
From: <alex_n_at_equinoxlt.com>
Date: Thu, 06 Aug 1998 17:03:26 GMT
Message-ID: <6qcnkt$uk8$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.
Date: Thu, 06 Aug 1998 17:03:26 GMT
Message-ID: <6qcnkt$uk8$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
[Quoted] -----== 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 - 19:03:26 CEST