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