xref: /PHP-8.3/ext/oci8/tests/error.phpt (revision a53e5617) 
1--TEST--
2oci_error() error message for parsing error
3--EXTENSIONS--
4oci8
5--SKIPIF--
6<?php
7require_once 'skipifconnectfailure.inc';
8$target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs: different error messages from TimesTen
9require __DIR__.'/skipif.inc';
10?>
11--FILE--
12<?php
13
14require __DIR__."/connect.inc";
15
16if (!empty($dbase)) {
17    var_dump(oci_connect($user, $password, $dbase));
18}
19else {
20    var_dump(oci_connect($user, $password));
21}
22
23var_dump($s = oci_parse($c, "WRONG SYNTAX"));
24var_dump(oci_execute($s));
25var_dump(oci_error($s));
26
27echo "Done\n";
28
29?>
30--EXPECTF--
31resource(%s) of type (oci8 connection)
32resource(%s) of type (oci8 statement)
33
34Warning: oci_execute(): ORA-00900: %s in %s on line %d
35bool(false)
36array(4) {
37  ["code"]=>
38  int(900)
39  ["message"]=>
40  string(%d) "ORA-00900: %s"
41  ["offset"]=>
42  int(0)
43  ["sqltext"]=>
44  string(12) "WRONG SYNTAX"
45}
46Done
47