Annotation of embedaddon/php/ext/oci8/tests/pecl_bug16842.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: PECL Bug #16842 (NO_DATA_FOUND exception is a warning)
3: --SKIPIF--
4: <?php
5: $target_dbs = array('oracledb' => true, 'timesten' => false); // test runs on these DBs
6: require(dirname(__FILE__).'/skipif.inc');
7: ?>
8: --INI--
9: error_reporting = E_WARNING
10: --FILE--
11: <?php
12:
13: require(dirname(__FILE__).'/connect.inc');
14:
15: // Run Test
16:
17: echo "Test 1\n";
18:
19: echo "Raises NO_DATA_FOUND\n";
20: $s = oci_parse($c, 'begin raise NO_DATA_FOUND; end;');
21: $e = oci_execute($s);
22: var_dump($e);
23: var_dump(oci_error($s));
24:
25: echo "Test 2\n";
26:
27: echo "Raises ZERO_DIVIDE\n";
28: $s = oci_parse($c, 'begin raise ZERO_DIVIDE; end;');
29: $e = oci_execute($s);
30: var_dump($e);
31: var_dump(oci_error($s));
32:
33: oci_close($c);
34:
35: ?>
36: ===DONE===
37: <?php exit(0); ?>
38: --EXPECTF--
39: Test 1
40: Raises NO_DATA_FOUND
41:
42: Warning: oci_execute(): ORA-01403: %s
43: ORA-06512: at line %d in %specl_bug16842.php on line %d
44: bool(false)
45: array(4) {
46: ["code"]=>
47: int(1403)
48: ["message"]=>
49: string(%d) "ORA-01403: %s
50: ORA-06512: at line 1"
51: ["offset"]=>
52: int(0)
53: ["sqltext"]=>
54: string(31) "begin raise NO_DATA_FOUND; end;"
55: }
56: Test 2
57: Raises ZERO_DIVIDE
58:
59: Warning: oci_execute(): ORA-01476: %s
60: ORA-06512: at line 1 in %s on line 19
61: bool(false)
62: array(4) {
63: ["code"]=>
64: int(1476)
65: ["message"]=>
66: string(%d) "ORA-01476: %s
67: ORA-06512: at line 1"
68: ["offset"]=>
69: int(0)
70: ["sqltext"]=>
71: string(29) "begin raise ZERO_DIVIDE; end;"
72: }
73: ===DONE===
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>