????JFIF??x?x????'
Server IP : 79.136.114.73 / Your IP : 3.16.130.16 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /proc/self/root/home/b8009/php-5.6.22/ext/oci8/tests/ |
Upload File : |
--TEST-- Check oci_pconnect try/catch end-of-scope with old_oci_close_semantics On --SKIPIF-- <?php if (!extension_loaded('oci8')) die ("skip no oci8 extension"); ?> --INI-- oci8.old_oci_close_semantics=1 --FILE-- <?php require(dirname(__FILE__).'/details.inc'); // Initialization $stmtarray = array( "drop table scope_try6_tab", "create table scope_try6_tab (c1 number)" ); if (!empty($dbase)) $c1 = oci_new_connect($user,$password,$dbase); else $c1 = oci_new_connect($user,$password); oci8_test_sql_execute($c1, $stmtarray); // Run Test echo "Test 1\n"; // Make errors throw exceptions set_error_handler(create_function('$x, $y', 'throw new Exception($y, $x);')); try { if (!empty($dbase)) $c = oci_pconnect($user,$password,$dbase); else $c = oci_pconnect($user,$password); $s = oci_parse($c, "insert into scope_try6_tab values (1)"); oci_execute($s, OCI_DEFAULT); // no commit $s = oci_parse($c, "insert into scope_try6_tab values (ABC)"); // syntax error -> throws exception oci_execute($s, OCI_DEFAULT); // no commit } catch (Exception $e) { echo "Caught Exception: ". $e->getMessage(), "\n"; var_dump($c); // Verify data is not yet committed $s1 = oci_parse($c1, "select * from scope_try6_tab"); oci_execute($s1); oci_fetch_all($s1, $r); var_dump($r); // Now commit oci_commit($c); } // Verify data was committed in the Catch block $s1 = oci_parse($c1, "select * from scope_try6_tab"); oci_execute($s1); oci_fetch_all($s1, $r); var_dump($r); // Cleanup $stmtarray = array( "drop table scope_try6_tab" ); oci8_test_sql_execute($c1, $stmtarray); echo "Done\n"; ?> --EXPECTF-- Test 1 Caught Exception: oci_execute(): ORA-%r(00984|57000: TT2957)%r: %s resource(%d) of type (oci8 persistent connection) array(1) { ["C1"]=> array(0) { } } array(1) { ["C1"]=> array(1) { [0]=> string(1) "1" } } Done