1--TEST-- 2Set and get of connection attributes with oci_close(). 3--SKIPIF-- 4<?php 5$target_dbs = array('oracledb' => true, 'timesten' => false); // test runs on these DBs 6require(__DIR__.'/skipif.inc'); 7 8if (strcasecmp($user, "system") && strcasecmp($user, "sys")) die("skip needs to be run as a DBA user"); 9if ($test_drcp) die("skip output might vary with DRCP"); 10 11preg_match('/.*Release ([[:digit:]]+)\.([[:digit:]]+)\.([[:digit:]]+)\.([[:digit:]]+)\.([[:digit:]]+)*/', oci_server_version($c), $matches); 12if (!(isset($matches[0]) && $matches[1] >= 10)) { 13 die("skip expected output only valid when using Oracle 10g or greater database server"); 14} 15?> 16--FILE-- 17<?php 18 19$testuser = 'testuser_attr_3'; // Used in conn_attr.inc 20$testpassword = 'testuser'; 21 22require(__DIR__."/conn_attr.inc"); 23 24echo"**Test Set and get values for the attributes with oci_close() ************\n"; 25// With oci_connect ,oci_pconnect ,oci_new_connect 26 27var_dump($conn1 = get_conn(1)); //oci_connect() 28set_attr($conn1,'ACTION',1); 29get_attr($conn1,'ACTION'); 30oci_close($conn1); 31 32// Open another connect and verify the value. 33var_dump($conn1 = get_conn(1)); //oci_connect() 34get_attr($conn1,'ACTION'); 35oci_close($conn1); 36 37var_dump($pconn1 = get_conn(2)); //oci_pconnect() 38set_attr($pconn1,'MODULE',2); 39get_attr($pconn1,'MODULE'); 40oci_close($pconn1); 41 42// Open another connect and verify the value. 43var_dump($pconn1 = get_conn(2)); //oci_pconnect() 44get_attr($pconn1,'MODULE'); 45oci_close($pconn1); 46 47var_dump($nconn1 = get_conn(3)); //oci_new_connect() 48set_attr($nconn1,'CLIENT_INFO',3); 49set_attr($nconn1,'CLIENT_IDENTIFIER',3); 50get_attr($nconn1,'CLIENT_INFO'); 51get_attr($nconn1,'CLIENT_IDENTIFIER'); 52oci_close($nconn1); 53 54// Open another connect and verify the value. 55var_dump($nconn1 = get_conn(3)); //oci_new_connect() 56get_attr($nconn1,'CLIENT_INFO'); 57get_attr($nconn1,'CLIENT_IDENTIFIER'); 58oci_close($nconn1); 59 60clean_up($c); 61echo "Done\n"; 62 63?> 64--EXPECTF-- 65**Test Set and get values for the attributes with oci_close() ************ 66Testing with oci_connect() 67resource(%d) of type (oci8 connection) 68Value of ACTION has been set successfully 69The value of ACTION is TASK1 70Testing with oci_connect() 71resource(%d) of type (oci8 connection) 72The value of ACTION is 73Testing with oci_pconnect() 74resource(%d) of type (oci8 persistent connection) 75Value of MODULE has been set successfully 76The value of MODULE is PHP TEST2 77Testing with oci_pconnect() 78resource(%d) of type (oci8 persistent connection) 79The value of MODULE is PHP TEST2 80Testing with oci_new_connect() 81resource(%d) of type (oci8 connection) 82Value of CLIENT_INFO has been set successfully 83Value of CLIENT_IDENTIFIER has been set successfully 84The value of CLIENT_INFO is INFO13 85The value of CLIENT_IDENTIFIER is ID003 86Testing with oci_new_connect() 87resource(%d) of type (oci8 connection) 88The value of CLIENT_INFO is 89The value of CLIENT_IDENTIFIER is 90Done 91
