This discussion is archived
3 Replies Latest reply: Sep 27, 2012 2:42 AM by 630995 RSS

OCI_ATTR_PREFETCH_ROWS and LOB values in oracle 11

630995 Newbie
Currently Being Moderated
In oracle 10 it was possible to use OCI_ATTR_PREFETCH_ROWS with LOB columns, as the documentation states:
Prefetching is not in effect if LONG columns are part of the query. Queries containing LOB columns can be prefetched, because the LOB locator, not the data, is returned by the query.

In oracle 11 the text has changed:
Prefetching is not in effect if LONG, LOB or Opaque Type columns (such as XMLType) are part of the query.

Is there something new in oracle 11 that can be used/set to reduce the number of roundtrips to the server for queries with LOB columns?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points