Pro*C/C++ cursors - basic question.

Hi !
One more question about cursors ...

What happens when i perform EXEC SQL open my_cursor ? Why it's more efficient to perform a fetch into a host array instead of a simple variable (in a loop) ? Is there any additional disk access for every fetch ?

Thanks in advance,
Gregory Received on Tue Jul 24 2001 - 10:34:09 CDT