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@xxxxxxxxxxx] 
> Sent: Friday, July 13, 2007 4:08 PM
> To: henry@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> 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


Other related posts: