Returning multiple rows into arrays?

In my application, which will be implemented using OCI or Pro*, i am returning rows of data for the programmer. Is there a performance difference between returning the results in batches into arrays as opposed to doing a single fetch in a loop? Why is one more efficient than the other?

When i have an open cursor on the server that has not exhausted its result set, what happens if the client crashes and doesn't properly close that cursor? Am i stuck with an open cursor that will remain until the server is bounced? This cursor doesn't lock anything does it? The lock remains durring the opening of the cursor - right?

-dave Received on Tue Feb 03 1998 - 00:00:00 CET