xref: /PHP-8.1/ext/oci8/tests/commit_002.phpt (revision b5a14e6c)
1--TEST--
2Test oci_commit failure
3--EXTENSIONS--
4oci8
5--SKIPIF--
6<?php
7$target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
8require(__DIR__.'/skipif.inc');
9?>
10--FILE--
11<?php
12
13require(__DIR__.'/connect.inc');
14
15// Initialization
16
17$stmtarray = array(
18    "drop table commit_002_tab",
19    "create table commit_002_tab
20     ( x int constraint commit_002_tab_check_x check ( x > 0 ) deferrable initially immediate,
21       y int constraint commit_002_tab_check_y check ( y > 0 ) deferrable initially deferred)"
22);
23
24oci8_test_sql_execute($c, $stmtarray);
25
26// Run Test
27
28echo "First Insert\n";
29$s = oci_parse($c, "insert into commit_002_tab values (-1, 1)");
30$r = @oci_execute($s, OCI_DEFAULT);
31if (!$r) {
32    $m = oci_error($s);
33    echo 'Could not execute: '. $m['message'] . "\n";
34}
35$r = oci_commit($c);
36if (!$r) {
37    $m = oci_error($c);
38    echo 'Could not commit: '. $m['message'] . "\n";
39}
40
41
42echo "Second Insert\n";
43$s = oci_parse($c, "insert into commit_002_tab values (1, -1)");
44$r = @oci_execute($s, OCI_NO_AUTO_COMMIT);
45if (!$r) {
46    $m = oci_error($s);
47    echo 'Could not execute: '. $m['message'] . "\n";
48}
49$r = oci_commit($c);
50if (!$r) {
51    $m = oci_error($c);
52    echo 'Could not commit: '. $m['message'] . "\n";
53}
54
55
56// Clean up
57
58$stmtarray = array(
59    "drop table commit_002_tab"
60);
61
62oci8_test_sql_execute($c, $stmtarray);
63
64?>
65--EXPECTF--
66First Insert
67Could not execute: ORA-02290: %s (%s.COMMIT_002_TAB_CHECK_X) %s
68Second Insert
69
70Warning: oci_commit(): ORA-02091: %s
71ORA-02290: %s (%s.COMMIT_002_TAB_CHECK_Y) %s in %scommit_002.php on line %d
72Could not commit: ORA-02091: %s
73ORA-02290: %s (%s.COMMIT_002_TAB_CHECK_Y) %s
74