1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
|
--TEST--
Test error handling when persistent connection is passed to oci_error()
--SKIPIF--
<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
--FILE--
<?php
// As part of the fix for Bug 42134, an error handling difference was
// noticed when oci_error() was passed a persistent connection. This
// was fixed and the behavior of oci_error() for all connections types
// was made consistent.
require(dirname(__FILE__).'/details.inc');
// Test parse error for normal connection
if (!empty($dbase)) {
$c1 = oci_connect($user,$password,$dbase);
}
else {
$c1 = oci_connect($user,$password);
}
$s = @oci_parse($c1, "select ' from dual");
if (!$s) {
echo "Normal connection: Parse error\n";
$m = oci_error($c1);
var_dump($m);
}
// Test parse error for new connection
if (!empty($dbase)) {
$c2 = oci_new_connect($user,$password,$dbase);
}
else {
$c2 = oci_new_connect($user,$password);
}
$s = @oci_parse($c2, "select ' from dual");
if (!$s) {
echo "New connection: Parse error\n";
$m = oci_error($c2);
var_dump($m);
}
// Test parse error for persistent connection
if (!empty($dbase)) {
$c3 = oci_pconnect($user,$password,$dbase);
}
else {
$c3 = oci_pconnect($user,$password);
}
$s = @oci_parse($c3, "select ' from dual");
if (!$s) {
echo "Persistent connection: Parse error\n";
$m = oci_error($c3);
var_dump($m);
}
// Verify that passing no connection doesn't affect future calls
$m = oci_error();
echo "No connection: error: ";
var_dump($m);
// Check the errors are still accessible in the respective handles
$m = oci_error($c1);
echo "Normal connection (take #2): Parse error: ";
echo $m["message"], "\n";
$m = oci_error($c2);
echo "New connection (take #2): Parse error: ";
echo $m["message"], "\n";
$m = oci_error($c3);
echo "Persistent connection (take #2): Parse error: ";
echo $m["message"], "\n";
// Now create a new error for a normal connection and check all again
$s = @oci_new_collection($c1, "ABC");
$m = oci_error($c1);
echo "Normal connection: New Collection error: ";
echo $m["message"], "\n";
$m = oci_error($c2);
echo "New connection (take #3): Parse error: ";
echo $m["message"], "\n";
$m = oci_error($c3);
echo "Persistent connection (take #3): Parse error: ";
echo $m["message"], "\n";
echo "Done\n";
?>
--EXPECTF--
Normal connection: Parse error
array(4) {
["code"]=>
int(1756)
["message"]=>
string(48) "ORA-01756: %s"
["offset"]=>
int(0)
["sqltext"]=>
string(0) ""
}
New connection: Parse error
array(4) {
["code"]=>
int(1756)
["message"]=>
string(48) "ORA-01756: %s"
["offset"]=>
int(0)
["sqltext"]=>
string(0) ""
}
Persistent connection: Parse error
array(4) {
["code"]=>
int(1756)
["message"]=>
string(48) "ORA-01756: %s"
["offset"]=>
int(0)
["sqltext"]=>
string(0) ""
}
No connection: error: bool(false)
Normal connection (take #2): Parse error: ORA-01756: %s
New connection (take #2): Parse error: ORA-01756: %s
Persistent connection (take #2): Parse error: ORA-01756: %s
Normal connection: New Collection error: OCI-22303: type ""."ABC" not found
New connection (take #3): Parse error: ORA-01756: %s
Persistent connection (take #3): Parse error: ORA-01756: %s
Done
|
