xref: /PHP-7.3/ext/oci8/tests/drcp_cclass1.phpt (revision a2c0f872)
1--TEST--
2DRCP: Test setting connection class inline
3--SKIPIF--
4<?php
5if (!extension_loaded('oci8')) die ("skip no oci8 extension");
6require(dirname(__FILE__).'/connect.inc');
7if (!$test_drcp) die("skip testing DRCP connection class only works in DRCP mode");
8// Looked for :pooled in EZ connect string
9if (strpos($dbase, "/") !== false && stripos($dbase, ":pooled") === false)
10    die('skip DRCP test requires a DRCP pooled server connection');
11if (strcasecmp($user, "system") && strcasecmp($user, "sys")) die("skip needs to be run as a DBA user");
12
13preg_match('/.*Release ([[:digit:]]+)\.([[:digit:]]+)\.([[:digit:]]+)\.([[:digit:]]+)\.([[:digit:]]+)*/', oci_server_version($c), $matches_sv);
14// This test in Oracle 12c needs a non-CDB or the root container
15if (isset($matches_sv[0]) && $matches_sv[1] >= 12) {
16    $s = oci_parse($c, "select nvl(sys_context('userenv', 'con_name'), 'notacdb') as dbtype from dual");
17    $r = @oci_execute($s);
18    if (!$r)
19        die('skip could not identify container type');
20    $r = oci_fetch_array($s);
21    if ($r['DBTYPE'] !== 'CDB$ROOT')
22        die('skip cannot run test using a PDB');
23}
24?>
25--FILE--
26<?php
27
28require(dirname(__FILE__)."/details.inc");
29
30// Initialization
31
32$t = time();
33$cc1 = 'cc1_'.$t;
34$cc2 = 'cc2_'.$t;
35
36// Run Test
37
38echo "Test 1\n";
39
40ini_set('oci8.connection_class', $cc1);
41$c = oci_pconnect($user, $password, $dbase);
42$s = oci_parse($c, "select * from dual");
43oci_execute($s);
44oci_fetch_all($s, $r);
45var_dump($r);
46
47echo "Test 2\n";
48
49ini_set('oci8.connection_class', $cc2);
50$c = oci_pconnect($user, $password, $dbase);
51$s = oci_parse($c, "select * from dual");
52oci_execute($s);
53oci_fetch_all($s, $r);
54var_dump($r);
55
56echo "Test 3\n";
57
58$s = oci_parse($c, "select cclass_name from v\$cpool_cc_stats where cclass_name like '%.cc__$t' order by cclass_name");
59oci_execute($s);
60oci_fetch_all($s, $r);
61var_dump($r);
62
63// Cleanup
64
65echo "Done\n";
66
67?>
68--EXPECTF--
69Test 1
70array(1) {
71  ["DUMMY"]=>
72  array(1) {
73    [0]=>
74    string(1) "X"
75  }
76}
77Test 2
78array(1) {
79  ["DUMMY"]=>
80  array(1) {
81    [0]=>
82    string(1) "X"
83  }
84}
85Test 3
86array(1) {
87  ["CCLASS_NAME"]=>
88  array(2) {
89    [0]=>
90    string(21) "%s.cc1_%d"
91    [1]=>
92    string(21) "%s.cc2_%d"
93  }
94}
95Done
96