Return to bug51291_2.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / oci8 / tests

Annotation of embedaddon/php/ext/oci8/tests/bug51291_2.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: Bug #51291 (oci_error() doesn't report last error when called two times)
                      3: --SKIPIF--
                      4: <?php
                      5: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs: different error messages from TimesTen
                      6: require(dirname(__FILE__).'/skipif.inc');
                      7: ?> 
                      8: --FILE--
                      9: <?php
                     10: 
                     11: require(dirname(__FILE__).'/connect.inc');
                     12: 
                     13: echo "\nTest 1 - Execute - after successful 2nd query with same statement\n";
                     14: 
                     15: $s = oci_parse($c, "declare e exception; begin if :bv = 1 then raise e; end if; end;");
                     16: $bv = 1;
                     17: oci_bind_by_name($s, ":bv", $bv);
                     18: $r = @oci_execute($s, OCI_DEFAULT);
                     19: if (!$r) { 
                     20:     var_dump(oci_error(), oci_error($c), oci_error($s));
                     21:     $bv = 0;
                     22:     $r = oci_execute($s, OCI_DEFAULT);
                     23:     echo "Execute status is ";
                     24:     if (is_null($r)) echo "null";
                     25:     else if ($r === false) echo "false";
                     26:     else if ($r === true) echo "true";
                     27:     else echo $r;
                     28:     echo "\n";
                     29:     echo "2nd call after successful execute\n";
                     30:     var_dump(oci_error(), oci_error($c), oci_error($s));
                     31: }
                     32: 
                     33: ?>
                     34: ===DONE===
                     35: <?php exit(0); ?>
                     36: --EXPECTF--
                     37: Test 1 - Execute - after successful 2nd query with same statement
                     38: bool(false)
                     39: bool(false)
                     40: array(4) {
                     41:   ["code"]=>
                     42:   int(6510)
                     43:   ["message"]=>
                     44:   string(72) "ORA-06510: PL/SQL: %s
                     45: ORA-06512: %s"
                     46:   ["offset"]=>
                     47:   int(0)
                     48:   ["sqltext"]=>
                     49:   string(64) "declare e exception; begin if :bv = 1 then raise e; end if; end;"
                     50: }
                     51: Execute status is true
                     52: 2nd call after successful execute
                     53: bool(false)
                     54: bool(false)
                     55: bool(false)
                     56: ===DONE===