PHP  
 PHP_HEAD
downloads | QA | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | my php.net 
 

Test Failure Report for ext/oci8/tests/imp_res_1.phpt ('Oracle Database 12c Implicit Result Sets: basic test')

Script

1: <?php
2:
3:
require(dirname(__FILE__).'/connect.inc');
4:
5:
// Initialization
6:
7:
$stmtarray = array(
8:     
"drop table imp_res_1_tab_1",
9:     
"create table imp_res_1_tab_1 (c1 number, c2 varchar2(10))",
10:     
"insert into imp_res_1_tab_1 values (1, 'abcde')",
11:     
"insert into imp_res_1_tab_1 values (2, 'fghij')",
12:     
"insert into imp_res_1_tab_1 values (3, 'klmno')",
13:
14:     
"drop table imp_res_1_tab_2",
15:     
"create table imp_res_1_tab_2 (c3 varchar2(1))",
16:     
"insert into imp_res_1_tab_2 values ('t')",
17:     
"insert into imp_res_1_tab_2 values ('u')",
18:     
"insert into imp_res_1_tab_2 values ('v')",
19:
20:     
"create or replace procedure imp_res_1_proc as
21:       c1 sys_refcursor;
22:     begin
23:       open c1 for select * from imp_res_1_tab_1 order by 1;
24:       dbms_sql.return_result(c1);
25:
26:       open c1 for select * from imp_res_1_tab_2 where rownum < 3 order by 1;
27:       dbms_sql.return_result(c1);
28:
29:       open c1 for select 99 from dual;
30:       dbms_sql.return_result (c1);
31:
32:       open c1 for select NULL, 'Z' from dual;
33:       dbms_sql.return_result (c1);
34:
35:       open c1 for select * from imp_res_1_tab_1 order by 1;
36:       dbms_sql.return_result(c1);
37:     end;"
38:
);
39:
40:
oci8_test_sql_execute($c$stmtarray);
41:
42:
// Run Test
43:
44:
echo "Test 1 - oci_fetch_assoc\n";
45:
$s oci_parse($c"begin imp_res_1_proc(); end;");
46:
oci_execute($s);
47: while ((
$row oci_fetch_assoc($s)) != false)
48:     
var_dump($row);
49:
50: echo 
"\nTest 2 - oci_fetch_object\n";
51:
$s oci_parse($c"begin imp_res_1_proc(); end;");
52:
oci_execute($s);
53: while ((
$row oci_fetch_object($s)) != false)
54:     
var_dump($row);
55:
56: echo 
"\nTest 3 - oci_fetch_row\n";
57:
$s oci_parse($c"begin imp_res_1_proc(); end;");
58:
oci_execute($s);
59: while ((
$row oci_fetch_row($s)) != false)
60:     
var_dump($row);
61:
62: echo 
"\nTest 4 - oci_fetch_array(OCI_ASSOC+OCI_RETURN_NULLS)\n";
63:
$s oci_parse($c"begin imp_res_1_proc(); end;");
64:
oci_execute($s);
65: while ((
$row oci_fetch_array($sOCI_ASSOC+OCI_RETURN_NULLS)) != false)
66:     
var_dump($row);
67:
68: echo 
"\nTest 5 - oci_fetch_array(OCI_ASSOC)\n";
69:
$s oci_parse($c"begin imp_res_1_proc(); end;");
70:
oci_execute($s);
71: while ((
$row oci_fetch_array($sOCI_ASSOC)) != false)
72:     
var_dump($row);
73:
74: echo 
"\nTest 6 - oci_fetch_array(OCI_NUM)\n";
75:
$s oci_parse($c"begin imp_res_1_proc(); end;");
76:
oci_execute($s);
77: while ((
$row oci_fetch_array($sOCI_NUM)) != false)
78:     
var_dump($row);
79:
80: echo 
"\nTest 7 - oci_fetch_array(OCI_BOTH)\n";
81:
$s oci_parse($c"begin imp_res_1_proc(); end;");
82:
oci_execute($s);
83: while ((
$row oci_fetch_array($sOCI_BOTH)) != false)
84:     
var_dump($row);
85:
86: echo 
"\nTest 8 - oci_fetch_array(OCI_BOTH+OCI_RETURN_NULLS)\n";
87:
$s oci_parse($c"begin imp_res_1_proc(); end;");
88:
oci_execute($s);
89: while ((
$row oci_fetch_array($sOCI_BOTH+OCI_RETURN_NULLS)) != false)
90:     
var_dump($row);
91:
92:
// Clean up
93:
94:
$stmtarray = array(
95:     
"drop procedure imp_res_1_proc",
96:     
"drop table imp_res_1_tab_1",
97:     
"drop table imp_res_1_tab_2"
98:
);
99:
100:
oci8_test_sql_execute($c$stmtarray);
101:
102:
?>
103:
===DONE===
104:

Expected

Test 1 - oci_fetch_assoc
array(2) {
  ["C1"]=>
  string(1) "1"
  ["C2"]=>
  string(5) "abcde"
}
array(2) {
  ["C1"]=>
  string(1) "2"
  ["C2"]=>
  string(5) "fghij"
}
array(2) {
  ["C1"]=>
  string(1) "3"
  ["C2"]=>
  string(5) "klmno"
}
array(1) {
  ["C3"]=>
  string(1) "t"
}
array(1) {
  ["C3"]=>
  string(1) "u"
}
array(1) {
  [99]=>
  string(2) "99"
}
array(2) {
  ["NULL"]=>
  NULL
  ["'Z'"]=>
  string(1) "Z"
}
array(2) {
  ["C1"]=>
  string(1) "1"
  ["C2"]=>
  string(5) "abcde"
}
array(2) {
  ["C1"]=>
  string(1) "2"
  ["C2"]=>
  string(5) "fghij"
}
array(2) {
  ["C1"]=>
  string(1) "3"
  ["C2"]=>
  string(5) "klmno"
}

Test 2 - oci_fetch_object
object(stdClass)#%d (2) {
  ["C1"]=>
  string(1) "1"
  ["C2"]=>
  string(5) "abcde"
}
object(stdClass)#%d (2) {
  ["C1"]=>
  string(1) "2"
  ["C2"]=>
  string(5) "fghij"
}
object(stdClass)#%d (2) {
  ["C1"]=>
  string(1) "3"
  ["C2"]=>
  string(5) "klmno"
}
object(stdClass)#%d (1) {
  ["C3"]=>
  string(1) "t"
}
object(stdClass)#%d (1) {
  ["C3"]=>
  string(1) "u"
}
object(stdClass)#%d (1) {
  [99]=>
  string(2) "99"
}
object(stdClass)#%d (2) {
  ["NULL"]=>
  NULL
  ["'Z'"]=>
  string(1) "Z"
}
object(stdClass)#%d (2) {
  ["C1"]=>
  string(1) "1"
  ["C2"]=>
  string(5) "abcde"
}
object(stdClass)#%d (2) {
  ["C1"]=>
  string(1) "2"
  ["C2"]=>
  string(5) "fghij"
}
object(stdClass)#%d (2) {
  ["C1"]=>
  string(1) "3"
  ["C2"]=>
  string(5) "klmno"
}

Test 3 - oci_fetch_row
array(2) {
  [0]=>
  string(1) "1"
  [1]=>
  string(5) "abcde"
}
array(2) {
  [0]=>
  string(1) "2"
  [1]=>
  string(5) "fghij"
}
array(2) {
  [0]=>
  string(1) "3"
  [1]=>
  string(5) "klmno"
}
array(1) {
  [0]=>
  string(1) "t"
}
array(1) {
  [0]=>
  string(1) "u"
}
array(1) {
  [0]=>
  string(2) "99"
}
array(2) {
  [0]=>
  NULL
  [1]=>
  string(1) "Z"
}
array(2) {
  [0]=>
  string(1) "1"
  [1]=>
  string(5) "abcde"
}
array(2) {
  [0]=>
  string(1) "2"
  [1]=>
  string(5) "fghij"
}
array(2) {
  [0]=>
  string(1) "3"
  [1]=>
  string(5) "klmno"
}

Test 4 - oci_fetch_array(OCI_ASSOC+OCI_RETURN_NULLS)
array(2) {
  ["C1"]=>
  string(1) "1"
  ["C2"]=>
  string(5) "abcde"
}
array(2) {
  ["C1"]=>
  string(1) "2"
  ["C2"]=>
  string(5) "fghij"
}
array(2) {
  ["C1"]=>
  string(1) "3"
  ["C2"]=>
  string(5) "klmno"
}
array(1) {
  ["C3"]=>
  string(1) "t"
}
array(1) {
  ["C3"]=>
  string(1) "u"
}
array(1) {
  [99]=>
  string(2) "99"
}
array(2) {
  ["NULL"]=>
  NULL
  ["'Z'"]=>
  string(1) "Z"
}
array(2) {
  ["C1"]=>
  string(1) "1"
  ["C2"]=>
  string(5) "abcde"
}
array(2) {
  ["C1"]=>
  string(1) "2"
  ["C2"]=>
  string(5) "fghij"
}
array(2) {
  ["C1"]=>
  string(1) "3"
  ["C2"]=>
  string(5) "klmno"
}

Test 5 - oci_fetch_array(OCI_ASSOC)
array(2) {
  ["C1"]=>
  string(1) "1"
  ["C2"]=>
  string(5) "abcde"
}
array(2) {
  ["C1"]=>
  string(1) "2"
  ["C2"]=>
  string(5) "fghij"
}
array(2) {
  ["C1"]=>
  string(1) "3"
  ["C2"]=>
  string(5) "klmno"
}
array(1) {
  ["C3"]=>
  string(1) "t"
}
array(1) {
  ["C3"]=>
  string(1) "u"
}
array(1) {
  [99]=>
  string(2) "99"
}
array(1) {
  ["'Z'"]=>
  string(1) "Z"
}
array(2) {
  ["C1"]=>
  string(1) "1"
  ["C2"]=>
  string(5) "abcde"
}
array(2) {
  ["C1"]=>
  string(1) "2"
  ["C2"]=>
  string(5) "fghij"
}
array(2) {
  ["C1"]=>
  string(1) "3"
  ["C2"]=>
  string(5) "klmno"
}

Test 6 - oci_fetch_array(OCI_NUM)
array(2) {
  [0]=>
  string(1) "1"
  [1]=>
  string(5) "abcde"
}
array(2) {
  [0]=>
  string(1) "2"
  [1]=>
  string(5) "fghij"
}
array(2) {
  [0]=>
  string(1) "3"
  [1]=>
  string(5) "klmno"
}
array(1) {
  [0]=>
  string(1) "t"
}
array(1) {
  [0]=>
  string(1) "u"
}
array(1) {
  [0]=>
  string(2) "99"
}
array(1) {
  [1]=>
  string(1) "Z"
}
array(2) {
  [0]=>
  string(1) "1"
  [1]=>
  string(5) "abcde"
}
array(2) {
  [0]=>
  string(1) "2"
  [1]=>
  string(5) "fghij"
}
array(2) {
  [0]=>
  string(1) "3"
  [1]=>
  string(5) "klmno"
}

Test 7 - oci_fetch_array(OCI_BOTH)
array(4) {
  [0]=>
  string(1) "1"
  ["C1"]=>
  string(1) "1"
  [1]=>
  string(5) "abcde"
  ["C2"]=>
  string(5) "abcde"
}
array(4) {
  [0]=>
  string(1) "2"
  ["C1"]=>
  string(1) "2"
  [1]=>
  string(5) "fghij"
  ["C2"]=>
  string(5) "fghij"
}
array(4) {
  [0]=>
  string(1) "3"
  ["C1"]=>
  string(1) "3"
  [1]=>
  string(5) "klmno"
  ["C2"]=>
  string(5) "klmno"
}
array(2) {
  [0]=>
  string(1) "t"
  ["C3"]=>
  string(1) "t"
}
array(2) {
  [0]=>
  string(1) "u"
  ["C3"]=>
  string(1) "u"
}
array(2) {
  [0]=>
  string(2) "99"
  [99]=>
  string(2) "99"
}
array(2) {
  [1]=>
  string(1) "Z"
  ["'Z'"]=>
  string(1) "Z"
}
array(4) {
  [0]=>
  string(1) "1"
  ["C1"]=>
  string(1) "1"
  [1]=>
  string(5) "abcde"
  ["C2"]=>
  string(5) "abcde"
}
array(4) {
  [0]=>
  string(1) "2"
  ["C1"]=>
  string(1) "2"
  [1]=>
  string(5) "fghij"
  ["C2"]=>
  string(5) "fghij"
}
array(4) {
  [0]=>
  string(1) "3"
  ["C1"]=>
  string(1) "3"
  [1]=>
  string(5) "klmno"
  ["C2"]=>
  string(5) "klmno"
}

Test 8 - oci_fetch_array(OCI_BOTH+OCI_RETURN_NULLS)
array(4) {
  [0]=>
  string(1) "1"
  ["C1"]=>
  string(1) "1"
  [1]=>
  string(5) "abcde"
  ["C2"]=>
  string(5) "abcde"
}
array(4) {
  [0]=>
  string(1) "2"
  ["C1"]=>
  string(1) "2"
  [1]=>
  string(5) "fghij"
  ["C2"]=>
  string(5) "fghij"
}
array(4) {
  [0]=>
  string(1) "3"
  ["C1"]=>
  string(1) "3"
  [1]=>
  string(5) "klmno"
  ["C2"]=>
  string(5) "klmno"
}
array(2) {
  [0]=>
  string(1) "t"
  ["C3"]=>
  string(1) "t"
}
array(2) {
  [0]=>
  string(1) "u"
  ["C3"]=>
  string(1) "u"
}
array(2) {
  [0]=>
  string(2) "99"
  [99]=>
  string(2) "99"
}
array(4) {
  [0]=>
  NULL
  ["NULL"]=>
  NULL
  [1]=>
  string(1) "Z"
  ["'Z'"]=>
  string(1) "Z"
}
array(4) {
  [0]=>
  string(1) "1"
  ["C1"]=>
  string(1) "1"
  [1]=>
  string(5) "abcde"
  ["C2"]=>
  string(5) "abcde"
}
array(4) {
  [0]=>
  string(1) "2"
  ["C1"]=>
  string(1) "2"
  [1]=>
  string(5) "fghij"
  ["C2"]=>
  string(5) "fghij"
}
array(4) {
  [0]=>
  string(1) "3"
  ["C1"]=>
  string(1) "3"
  [1]=>
  string(5) "klmno"
  ["C2"]=>
  string(5) "klmno"
}
===DONE===

Output

***********************************************************************
Fatal NI connect error 12541, connecting to:
 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=php)(HOST=nex2.php.net)(USER=nlopess)))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))

  VERSION INFORMATION:
	TNS for Linux: Version 11.2.0.2.0 - Beta
	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
  Time: 17-JUN-2018 05:42:54
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12541
    TNS-12541: TNS:no listener
    ns secondary err code: 12560
    nt main err code: 511
    TNS-00511: No listener

Fatal error: connect.inc: Failed to connect as 'system' to 'localhost/XE': ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect.inc on line 14
    nt secondary err code: 111
    nt OS err code: 0

Diff

001+ ***********************************************************************
002+ Fatal NI connect error 12541, connecting to:
003+  (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=php)(HOST=nex2.php.net)(USER=nlopess)))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
004+ 
005+   VERSION INFORMATION:
006+ 	TNS for Linux: Version 11.2.0.2.0 - Beta
007+ 	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
008+   Time: 17-JUN-2018 05:42:54
009+   Tracing not turned on.
010+   Tns error struct:
011+     ns main err code: 12541
012+     TNS-12541: TNS:no listener
013+     ns secondary err code: 12560
014+     nt main err code: 511
015+     TNS-00511: No listener
016+ 
017+ Fatal error: connect.inc: Failed to connect as 'system' to 'localhost/XE': ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect.inc on line 14
018+     nt secondary err code: 111
019+     nt OS err code: 0
001- Test 1 - oci_fetch_assoc
002- array(2) {
003-   ["C1"]=>
004-   string(1) "1"
005-   ["C2"]=>
006-   string(5) "abcde"
007- }
008- array(2) {
009-   ["C1"]=>
010-   string(1) "2"
011-   ["C2"]=>
012-   string(5) "fghij"
013- }
014- array(2) {
015-   ["C1"]=>
016-   string(1) "3"
017-   ["C2"]=>
018-   string(5) "klmno"
019- }
020- array(1) {
021-   ["C3"]=>
022-   string(1) "t"
023- }
024- array(1) {
025-   ["C3"]=>
026-   string(1) "u"
027- }
028- array(1) {
029-   [99]=>
030-   string(2) "99"
031- }
032- array(2) {
033-   ["NULL"]=>
034-   NULL
035-   ["'Z'"]=>
036-   string(1) "Z"
037- }
038- array(2) {
039-   ["C1"]=>
040-   string(1) "1"
041-   ["C2"]=>
042-   string(5) "abcde"
043- }
044- array(2) {
045-   ["C1"]=>
046-   string(1) "2"
047-   ["C2"]=>
048-   string(5) "fghij"
049- }
050- array(2) {
051-   ["C1"]=>
052-   string(1) "3"
053-   ["C2"]=>
054-   string(5) "klmno"
055- }
056- 
057- Test 2 - oci_fetch_object
058- object(stdClass)#%d (2) {
059-   ["C1"]=>
060-   string(1) "1"
061-   ["C2"]=>
062-   string(5) "abcde"
063- }
064- object(stdClass)#%d (2) {
065-   ["C1"]=>
066-   string(1) "2"
067-   ["C2"]=>
068-   string(5) "fghij"
069- }
070- object(stdClass)#%d (2) {
071-   ["C1"]=>
072-   string(1) "3"
073-   ["C2"]=>
074-   string(5) "klmno"
075- }
076- object(stdClass)#%d (1) {
077-   ["C3"]=>
078-   string(1) "t"
079- }
080- object(stdClass)#%d (1) {
081-   ["C3"]=>
082-   string(1) "u"
083- }
084- object(stdClass)#%d (1) {
085-   [99]=>
086-   string(2) "99"
087- }
088- object(stdClass)#%d (2) {
089-   ["NULL"]=>
090-   NULL
091-   ["'Z'"]=>
092-   string(1) "Z"
093- }
094- object(stdClass)#%d (2) {
095-   ["C1"]=>
096-   string(1) "1"
097-   ["C2"]=>
098-   string(5) "abcde"
099- }
100- object(stdClass)#%d (2) {
101-   ["C1"]=>
102-   string(1) "2"
103-   ["C2"]=>
104-   string(5) "fghij"
105- }
106- object(stdClass)#%d (2) {
107-   ["C1"]=>
108-   string(1) "3"
109-   ["C2"]=>
110-   string(5) "klmno"
111- }
112- 
113- Test 3 - oci_fetch_row
114- array(2) {
115-   [0]=>
116-   string(1) "1"
117-   [1]=>
118-   string(5) "abcde"
119- }
120- array(2) {
121-   [0]=>
122-   string(1) "2"
123-   [1]=>
124-   string(5) "fghij"
125- }
126- array(2) {
127-   [0]=>
128-   string(1) "3"
129-   [1]=>
130-   string(5) "klmno"
131- }
132- array(1) {
133-   [0]=>
134-   string(1) "t"
135- }
136- array(1) {
137-   [0]=>
138-   string(1) "u"
139- }
140- array(1) {
141-   [0]=>
142-   string(2) "99"
143- }
144- array(2) {
145-   [0]=>
146-   NULL
147-   [1]=>
148-   string(1) "Z"
149- }
150- array(2) {
151-   [0]=>
152-   string(1) "1"
153-   [1]=>
154-   string(5) "abcde"
155- }
156- array(2) {
157-   [0]=>
158-   string(1) "2"
159-   [1]=>
160-   string(5) "fghij"
161- }
162- array(2) {
163-   [0]=>
164-   string(1) "3"
165-   [1]=>
166-   string(5) "klmno"
167- }
168- 
169- Test 4 - oci_fetch_array(OCI_ASSOC+OCI_RETURN_NULLS)
170- array(2) {
171-   ["C1"]=>
172-   string(1) "1"
173-   ["C2"]=>
174-   string(5) "abcde"
175- }
176- array(2) {
177-   ["C1"]=>
178-   string(1) "2"
179-   ["C2"]=>
180-   string(5) "fghij"
181- }
182- array(2) {
183-   ["C1"]=>
184-   string(1) "3"
185-   ["C2"]=>
186-   string(5) "klmno"
187- }
188- array(1) {
189-   ["C3"]=>
190-   string(1) "t"
191- }
192- array(1) {
193-   ["C3"]=>
194-   string(1) "u"
195- }
196- array(1) {
197-   [99]=>
198-   string(2) "99"
199- }
200- array(2) {
201-   ["NULL"]=>
202-   NULL
203-   ["'Z'"]=>
204-   string(1) "Z"
205- }
206- array(2) {
207-   ["C1"]=>
208-   string(1) "1"
209-   ["C2"]=>
210-   string(5) "abcde"
211- }
212- array(2) {
213-   ["C1"]=>
214-   string(1) "2"
215-   ["C2"]=>
216-   string(5) "fghij"
217- }
218- array(2) {
219-   ["C1"]=>
220-   string(1) "3"
221-   ["C2"]=>
222-   string(5) "klmno"
223- }
224- 
225- Test 5 - oci_fetch_array(OCI_ASSOC)
226- array(2) {
227-   ["C1"]=>
228-   string(1) "1"
229-   ["C2"]=>
230-   string(5) "abcde"
231- }
232- array(2) {
233-   ["C1"]=>
234-   string(1) "2"
235-   ["C2"]=>
236-   string(5) "fghij"
237- }
238- array(2) {
239-   ["C1"]=>
240-   string(1) "3"
241-   ["C2"]=>
242-   string(5) "klmno"
243- }
244- array(1) {
245-   ["C3"]=>
246-   string(1) "t"
247- }
248- array(1) {
249-   ["C3"]=>
250-   string(1) "u"
251- }
252- array(1) {
253-   [99]=>
254-   string(2) "99"
255- }
256- array(1) {
257-   ["'Z'"]=>
258-   string(1) "Z"
259- }
260- array(2) {
261-   ["C1"]=>
262-   string(1) "1"
263-   ["C2"]=>
264-   string(5) "abcde"
265- }
266- array(2) {
267-   ["C1"]=>
268-   string(1) "2"
269-   ["C2"]=>
270-   string(5) "fghij"
271- }
272- array(2) {
273-   ["C1"]=>
274-   string(1) "3"
275-   ["C2"]=>
276-   string(5) "klmno"
277- }
278- 
279- Test 6 - oci_fetch_array(OCI_NUM)
280- array(2) {
281-   [0]=>
282-   string(1) "1"
283-   [1]=>
284-   string(5) "abcde"
285- }
286- array(2) {
287-   [0]=>
288-   string(1) "2"
289-   [1]=>
290-   string(5) "fghij"
291- }
292- array(2) {
293-   [0]=>
294-   string(1) "3"
295-   [1]=>
296-   string(5) "klmno"
297- }
298- array(1) {
299-   [0]=>
300-   string(1) "t"
301- }
302- array(1) {
303-   [0]=>
304-   string(1) "u"
305- }
306- array(1) {
307-   [0]=>
308-   string(2) "99"
309- }
310- array(1) {
311-   [1]=>
312-   string(1) "Z"
313- }
314- array(2) {
315-   [0]=>
316-   string(1) "1"
317-   [1]=>
318-   string(5) "abcde"
319- }
320- array(2) {
321-   [0]=>
322-   string(1) "2"
323-   [1]=>
324-   string(5) "fghij"
325- }
326- array(2) {
327-   [0]=>
328-   string(1) "3"
329-   [1]=>
330-   string(5) "klmno"
331- }
332- 
333- Test 7 - oci_fetch_array(OCI_BOTH)
334- array(4) {
335-   [0]=>
336-   string(1) "1"
337-   ["C1"]=>
338-   string(1) "1"
339-   [1]=>
340-   string(5) "abcde"
341-   ["C2"]=>
342-   string(5) "abcde"
343- }
344- array(4) {
345-   [0]=>
346-   string(1) "2"
347-   ["C1"]=>
348-   string(1) "2"
349-   [1]=>
350-   string(5) "fghij"
351-   ["C2"]=>
352-   string(5) "fghij"
353- }
354- array(4) {
355-   [0]=>
356-   string(1) "3"
357-   ["C1"]=>
358-   string(1) "3"
359-   [1]=>
360-   string(5) "klmno"
361-   ["C2"]=>
362-   string(5) "klmno"
363- }
364- array(2) {
365-   [0]=>
366-   string(1) "t"
367-   ["C3"]=>
368-   string(1) "t"
369- }
370- array(2) {
371-   [0]=>
372-   string(1) "u"
373-   ["C3"]=>
374-   string(1) "u"
375- }
376- array(2) {
377-   [0]=>
378-   string(2) "99"
379-   [99]=>
380-   string(2) "99"
381- }
382- array(2) {
383-   [1]=>
384-   string(1) "Z"
385-   ["'Z'"]=>
386-   string(1) "Z"
387- }
388- array(4) {
389-   [0]=>
390-   string(1) "1"
391-   ["C1"]=>
392-   string(1) "1"
393-   [1]=>
394-   string(5) "abcde"
395-   ["C2"]=>
396-   string(5) "abcde"
397- }
398- array(4) {
399-   [0]=>
400-   string(1) "2"
401-   ["C1"]=>
402-   string(1) "2"
403-   [1]=>
404-   string(5) "fghij"
405-   ["C2"]=>
406-   string(5) "fghij"
407- }
408- array(4) {
409-   [0]=>
410-   string(1) "3"
411-   ["C1"]=>
412-   string(1) "3"
413-   [1]=>
414-   string(5) "klmno"
415-   ["C2"]=>
416-   string(5) "klmno"
417- }
418- 
419- Test 8 - oci_fetch_array(OCI_BOTH+OCI_RETURN_NULLS)
420- array(4) {
421-   [0]=>
422-   string(1) "1"
423-   ["C1"]=>
424-   string(1) "1"
425-   [1]=>
426-   string(5) "abcde"
427-   ["C2"]=>
428-   string(5) "abcde"
429- }
430- array(4) {
431-   [0]=>
432-   string(1) "2"
433-   ["C1"]=>
434-   string(1) "2"
435-   [1]=>
436-   string(5) "fghij"
437-   ["C2"]=>
438-   string(5) "fghij"
439- }
440- array(4) {
441-   [0]=>
442-   string(1) "3"
443-   ["C1"]=>
444-   string(1) "3"
445-   [1]=>
446-   string(5) "klmno"
447-   ["C2"]=>
448-   string(5) "klmno"
449- }
450- array(2) {
451-   [0]=>
452-   string(1) "t"
453-   ["C3"]=>
454-   string(1) "t"
455- }
456- array(2) {
457-   [0]=>
458-   string(1) "u"
459-   ["C3"]=>
460-   string(1) "u"
461- }
462- array(2) {
463-   [0]=>
464-   string(2) "99"
465-   [99]=>
466-   string(2) "99"
467- }
468- array(4) {
469-   [0]=>
470-   NULL
471-   ["NULL"]=>
472-   NULL
473-   [1]=>
474-   string(1) "Z"
475-   ["'Z'"]=>
476-   string(1) "Z"
477- }
478- array(4) {
479-   [0]=>
480-   string(1) "1"
481-   ["C1"]=>
482-   string(1) "1"
483-   [1]=>
484-   string(5) "abcde"
485-   ["C2"]=>
486-   string(5) "abcde"
487- }
488- array(4) {
489-   [0]=>
490-   string(1) "2"
491-   ["C1"]=>
492-   string(1) "2"
493-   [1]=>
494-   string(5) "fghij"
495-   ["C2"]=>
496-   string(5) "fghij"
497- }
498- array(4) {
499-   [0]=>
500-   string(1) "3"
501-   ["C1"]=>
502-   string(1) "3"
503-   [1]=>
504-   string(5) "klmno"
505-   ["C2"]=>
506-   string(5) "klmno"
507- }
508- ===DONE===

 

Generated at Mon, 18 Jun 2018 17:33:50 +0000 (20 hours ago)

Copyright © 2005-2018 The PHP Group
All rights reserved.