Annotation of embedaddon/php/ext/oci8/tests/default_prefetch2.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: oci8.default_prefetch ini option
3: --SKIPIF--
4: <?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
5: --INI--
6: oci8.default_prefetch=100
7: --FILE--
8: <?php
9:
10: require(dirname(__FILE__)."/connect.inc");
11:
12: // Initialize
13:
14: $stmtarray = array(
15: "drop table default_prefetch2_tab",
16: "create table default_prefetch2_tab (id number, value number)",
17: "insert into default_prefetch2_tab (id, value) values (1,1)",
18: "insert into default_prefetch2_tab (id, value) values (1,1)",
19: "insert into default_prefetch2_tab (id, value) values (1,1)",
20: );
21:
22: oci8_test_sql_execute($c, $stmtarray);
23:
24: // Run Test
25:
26: $select_sql = "select * from default_prefetch2_tab";
27:
28: if (!($s = oci_parse($c, $select_sql))) {
29: die("oci_parse(select) failed!\n");
30: }
31:
32: var_dump(oci_set_prefetch($s, 10));
33:
34: if (!oci_execute($s)) {
35: die("oci_execute(select) failed!\n");
36: }
37:
38: var_dump(oci_fetch($s));
39: var_dump(oci_num_rows($s));
40:
41: // Cleanup
42:
43: $stmtarray = array(
44: "drop table default_prefetch2_tab"
45: );
46:
47: oci8_test_sql_execute($c, $stmtarray);
48:
49: echo "Done\n";
50: ?>
51: --EXPECT--
52: bool(true)
53: bool(true)
54: int(1)
55: Done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>