fetch in PL/SQL

From: <alex_n_at_equinoxlt.com>
Date: Thu, 06 Aug 1998 17:02:51 GMT
Message-ID: <6qcnjr$uho$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:51 CDT