Annotation of embedaddon/php/ext/oci8/tests/statement_cache.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: statement cache
3: --SKIPIF--
4: <?php
5: $target_dbs = array('oracledb' => true, 'timesten' => true); // test runs on these DBs
6: require(dirname(__FILE__).'/skipif.inc');
7: ?>
8: --FILE--
9: <?php
10:
11: // Note: with TimesTen, the column will be called "EXP"
12:
13: require dirname(__FILE__)."/connect.inc";
14:
15: $pc = oci_pconnect($user, $password, $dbase);
16:
17: $stmt = oci_parse($pc, "select 1+3 from dual");
18: oci_execute($stmt);
19: var_dump(oci_fetch_array($stmt));
20:
21: $stmt = oci_parse($pc, "select 1+3 from dual");
22: oci_execute($stmt);
23: var_dump(oci_fetch_array($stmt));
24:
25: echo "Done\n";
26: ?>
27: --EXPECTF--
28: array(2) {
29: [0]=>
30: string(1) "4"
31: ["%r(1\+3|EXP)%r"]=>
32: string(1) "4"
33: }
34: array(2) {
35: [0]=>
36: string(1) "4"
37: ["%r(1\+3|EXP)%r"]=>
38: string(1) "4"
39: }
40: Done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>