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

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 24 Jul 2001 10:21:13 -0700
Message-ID: <9jkaq902inv@drn.newsguy.com>

In article <176ffe5.0107240734.58a2a206_at_posting.google.com>, gregory_at_harmonycom.com says...
>
>Hi !
>One more question about cursors ...
>
>What happens when i perform EXEC SQL open my_cursor ?

depends, normal select (no for update) -- just a parse if needed. insert/update/delete -- everything happens

>Why it's more efficient to perform a fetch into a host
>array instead of a simple variable (in a loop) ?

reduced network round trips and process to process comunication

>Is there any additional disk access for every fetch ?
>

no, but there will be additional latching maybe and definitely extra work going back and forth.

>Thanks in advance,
>Gregory

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Tue Jul 24 2001 - 12:21:13 CDT