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