Annotation of embedaddon/php/ext/oci8/tests/drcp_scope2.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: DRCP: oci_new_connect() and oci_connect with scope end when oci8.old_oci_close_semantics OFF
3: --SKIPIF--
4: <?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
5: --INI--
6: oci8.old_oci_close_semantics=0
7: --FILE--
8: <?php
9:
10: require dirname(__FILE__)."/drcp_functions.inc";
11: require dirname(__FILE__)."/details.inc";
12:
13: // Scope considered here is the functional scope
14: // Test will open a connection within a function (function 1).
15: // Update a table
16: // Open another connection from function 2.
17: // When the scope ends the txn is rolled back and hence the updated value
18: // will not be reflected for oci_connect and oci_new_connect.
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: // OCI_NEW_CONNECT
26: $conn_type = 1;
27: echo "This is with a OCI_NEW_CONNECT\n";
28: function1($user,$password,$dbase,$conn_type);
29:
30: // Should return the OLD value
31: function2($user,$password,$dbase,$conn_type);
32:
33: // OCI_CONNECT
34: $conn_type = 2;
35: echo "\n\nThis is with a OCI_CONNECT\n";
36: function1($user,$password,$dbase,$conn_type);
37:
38: // Should return the OLD value
39: function2($user,$password,$dbase,$conn_type);
40:
41: //This is the first scope for the script
42:
43: function function1($user,$password,$dbase,$conn_type)
44: {
45: switch($conn_type)
46: {
47: case 1:
48: var_dump($conn1 = oci_new_connect($user,$password,$dbase));
49: break;
50: case 2:
51: var_dump($conn1 = oci_connect($user,$password,$dbase));
52: break;
53: }
54: drcp_update_table($conn1);
55: }
56:
57: // This is the second scope
58:
59: function function2($user,$password,$dbase,$conn_type)
60: {
61: switch($conn_type)
62: {
63: case 1:
64: var_dump($conn1 = oci_new_connect($user,$password,$dbase));
65: break;
66: case 2:
67: var_dump($conn1 = oci_connect($user,$password,$dbase));
68: break;
69: }
70: drcp_select_value($conn1);
71: }
72: drcp_drop_table($c);
73: oci_close($c);
74:
75: echo "Done\n";
76:
77: ?>
78: --EXPECTF--
79: This is with a OCI_NEW_CONNECT
80: resource(%d) of type (oci8 connection)
81: Update done-- DEPT value has been set to NEWDEPT
82: resource(%d) of type (oci8 connection)
83: The value of DEPT for id 105 is HR
84:
85:
86: This is with a OCI_CONNECT
87: resource(%d) of type (oci8 connection)
88: Update done-- DEPT value has been set to NEWDEPT
89: resource(%d) of type (oci8 connection)
90: The value of DEPT for id 105 is HR
91: Done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>