RE: Does EXEC do a FETCH?

Possibly, but do you know if prefetching is turned on by default in sqlplus? Also, that still doesn't explain what the FETCH r=1 does, as the record has already been (pre)fetched. It still looks like the order displayed in the 10046 trace is not the order of events as they actually occur.

Henry

> -----Original Message-----
> From: Allen, Brandon [mailto:Brandon.Allen_at_oneneck.com]
> Sent: Friday, July 13, 2007 4:08 PM
> To: henry_at_itasoftware.com; oracle-l_at_freelists.org
> Subject: RE: Does EXEC do a FETCH?
>
>
> Sounds like prefetching at work - I think it has been on by default
> since 8i or 9i:
>
> http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96584
> /oci04sql.
> htm#428255
>
> Privileged/Confidential Information may be contained in this
> message or attachments hereto. Please advise immediately if
> you or your employer do not consent to Internet email for
> messages of this kind. Opinions, conclusions and other
> information in this message that do not relate to the
> official business of this company shall be understood as
> neither given nor endorsed by it.
>
>

--
http://www.freelists.org/webpage/oracle-l