Return to drcp_scope3.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: DRCP: oci_pconnect() with scope end when oci8.old_oci_close_semantics ON
                      3: --SKIPIF--
                      4: <?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
                      5: --INI--
                      6: oci8.old_oci_close_semantics=1
                      7: --FILE--
                      8: <?php
                      9: 
                     10: require dirname(__FILE__)."/drcp_functions.inc";
                     11: require dirname(__FILE__)."/details.inc";
                     12: 
                     13: // The test opens a connection within function1 and updates a table
                     14: // (without committing).  Another connection is opened from function
                     15: // 2, and the table queried.  When function1 ends, the connection from
                     16: // function1 is not closed, so the updated value will be seen in
                     17: // function2.  Also the table can't be dropped because an uncommitted
                     18: // transaction exists.
                     19: 
                     20: // Create the table
                     21: $c = oci_new_connect($user,$password,$dbase);
                     22: @drcp_drop_table($c);
                     23: drcp_create_table($c);
                     24: 
                     25: echo "This is with a OCI_PCONNECT\n";
                     26: function1($user,$password,$dbase);
                     27: 
                     28: // Should return the OLD value
                     29: function2($user,$password,$dbase);
                     30: 
                     31: // This is the first scope for the script
                     32: 
                     33: function function1($user,$password,$dbase)
                     34: {
                     35:        var_dump($c = oci_pconnect($user,$password,$dbase));
                     36:        drcp_update_table($c);
                     37: }
                     38: 
                     39: // This is the second scope
                     40: 
                     41: function function2($user,$password,$dbase)
                     42: {
                     43:        var_dump($c = oci_pconnect($user,$password,$dbase));
                     44:        drcp_select_value($c);
                     45: }
                     46: 
                     47: drcp_drop_table($c);
                     48: oci_close($c);
                     49: 
                     50: echo "Done\n";
                     51: 
                     52: ?>
                     53: --EXPECTF--
                     54: This is with a OCI_PCONNECT
                     55: resource(%d) of type (oci8 persistent connection)
                     56: Update done-- DEPT value has been set to NEWDEPT
                     57: resource(%d) of type (oci8 persistent connection)
                     58: The value of DEPT for id 105 is NEWDEPT
                     59: 
                     60: Warning: oci_execute(): ORA-00054: %s
                     61: Done