1--TEST--
2oci8.default_prefetch ini option
3--SKIPIF--
4<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
5--INI--
6oci8.default_prefetch=20
7--FILE--
8<?php
9
10require(dirname(__FILE__)."/connect.inc");
11
12// Initialize
13
14$stmtarray = array(
15    "drop table default_prefetch_tab",
16    "create table default_prefetch_tab (id number, value number)",
17    "insert into default_prefetch_tab (id, value) values (1,1)",
18    "insert into default_prefetch_tab (id, value) values (1,1)",
19    "insert into default_prefetch_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_prefetch_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));
37
38var_dump(oci_num_rows($s));
39
40// Cleanup
41
42$stmtarray = array(
43    "drop table default_prefetch_tab"
44);
45
46oci8_test_sql_execute($c, $stmtarray);
47
48echo "Done\n";
49?>
50--EXPECT--
51bool(true)
52int(1)
53Done
54