reference/oci8/functions/oci-set-prefetch.xml
f80105b4fc1196bd8d5fecb98d686b580b1ff65d
f80105b4fc1196bd8d5fecb98d686b580b1ff65d
...
...
@@ -96,39 +96,6 @@
96
96
</para>
97
97
</refsect1>
98
98
99
-
<refsect1 role="changelog">
100
-
&reftitle.changelog;
101
-
<para>
102
-
<informaltable>
103
-
<tgroup cols="2">
104
-
<thead>
105
-
<row>
106
-
<entry>&Version;</entry>
107
-
<entry>&Description;</entry>
108
-
</row>
109
-
</thead>
110
-
<tbody>
111
-
<row>
112
-
<entry>5.3.2 (PECL OCI8 1.4)</entry>
113
-
<entry>
114
-
Before this release, <parameter>rows</parameter> must be >= 1.
115
-
</entry>
116
-
</row>
117
-
<row>
118
-
<entry>5.3.0 (PECL OCI8 1.3.4)</entry>
119
-
<entry>
120
-
Before this release, prefetching was limited to the lesser
121
-
of <parameter>rows</parameter> rows and 1024
122
-
* <parameter>rows</parameter> bytes. The byte size
123
-
restriction has now been removed.
124
-
</entry>
125
-
</row>
126
-
</tbody>
127
-
</tgroup>
128
-
</informaltable>
129
-
</para>
130
-
</refsect1>
131
-
132
99
<refsect1 role="examples">
133
100
&reftitle.examples;
134
101
<para>
...
...
@@ -211,10 +178,10 @@ oci_close($conn);
211
178
<para>
212
179
If PHP OCI8 fetches from a REF CURSOR and then passes the REF
213
180
CURSOR back to a second PL/SQL procedure for further processing,
214
-
then set the REF CURSOR prefetch count to <constant>0</constant> to
181
+
then set the REF CURSOR prefetch count to <literal>0</literal> to
215
182
avoid rows being "lost" from the result set. The prefetch value is
216
183
the number of extra rows fetched in each OCI8 internal request to
217
-
the database, so setting it to <constant>0</constant> means only
184
+
the database, so setting it to <literal>0</literal> means only
218
185
fetch one row at a time.
219
186
<example>
220
187
<title>Setting the prefetch value when passing a REF CURSOR back to Oracle</title>
...
...
@@ -232,7 +199,6 @@ oci_execute($stid);
232
199
233
200
// Display two rows, but don't prefetch any extra rows otherwise
234
201
// those extra rows would not be passed back to myproc_use_rc().
235
-
// A prefetch value of 0 is allowed in PHP 5.3.2 and PECL OCI8 1.4
236
202
oci_set_prefetch($refcur, 0);
237
203
oci_execute($refcur);
238
204
$row = oci_fetch_array($refcur);
239
205