1--TEST--
2oci8.default_prefetch ini option
3--EXTENSIONS--
4oci8
5--SKIPIF--
6<?php
7require_once 'skipifconnectfailure.inc';
8?>
9--INI--
10oci8.default_prefetch=100
11--FILE--
12<?php
13
14require __DIR__.'/connect.inc';
15
16// Initialize
17
18$stmtarray = array(
19    "drop table default_prefetch2_tab",
20    "create table default_prefetch2_tab (id number, value number)",
21    "insert into default_prefetch2_tab (id, value) values (1,1)",
22    "insert into default_prefetch2_tab (id, value) values (1,1)",
23    "insert into default_prefetch2_tab (id, value) values (1,1)",
24);
25
26oci8_test_sql_execute($c, $stmtarray);
27
28// Run Test
29
30$select_sql = "select * from default_prefetch2_tab";
31
32if (!($s = oci_parse($c, $select_sql))) {
33    die("oci_parse(select) failed!\n");
34}
35
36var_dump(oci_set_prefetch($s, 10));
37
38if (!oci_execute($s)) {
39    die("oci_execute(select) failed!\n");
40}
41
42var_dump(oci_fetch($s));
43var_dump(oci_num_rows($s));
44
45// Cleanup
46
47$stmtarray = array(
48    "drop table default_prefetch2_tab"
49);
50
51oci8_test_sql_execute($c, $stmtarray);
52
53echo "Done\n";
54?>
55--EXPECT--
56bool(true)
57bool(true)
58int(1)
59Done
60