1--TEST--
2Bug #27303 (OCIBindByName binds numeric PHP values as characters)
3--SKIPIF--
4<?php
5if (!extension_loaded('oci8')) die ("skip no oci8 extension");
6require(dirname(__FILE__)."/connect.inc");
7// The bind buffer size edge cases seem to change each DB version.
8if (preg_match('/Release 10\.2\.0\.3/', oci_server_version($c), $matches) !== 1) {
9    if (preg_match('/Release 11\.1\.0\.6/', oci_server_version($c), $matches) !== 1) {
10        if (preg_match('/Release 11\.2\.0\.3/', oci_server_version($c), $matches) !== 1) {
11            die("skip expected output only valid when using specific Oracle database versions");
12        }
13    }
14}
15?>
16--FILE--
17<?php
18
19require dirname(__FILE__).'/connect.inc';
20
21$stmtarray = array(
22    "drop sequence myseq",
23    "drop table mytab",
24    "create sequence myseq",
25    "create table mytab (mydata varchar2(20), seqcol number)"
26);
27
28oci8_test_sql_execute($c, $stmtarray);
29
30define('MYLIMIT', 200);
31define('INITMYBV', 11);
32
33$stmt = "insert into mytab (mydata, seqcol) values ('Some data', myseq.nextval) returning seqcol into :mybv";
34
35$stid = OCIParse($c, $stmt);
36if (!$stid) { echo "Parse error"; die; }
37
38$mybv = INITMYBV;
39$r = OCIBindByName($stid, ':MYBV', $mybv);
40if (!$r) { echo "Bind error"; die; }
41
42for ($i = 1; $i < MYLIMIT; $i++) {
43	$r = OCIExecute($stid, OCI_DEFAULT);
44	if (!$r) { echo "Execute error"; die; }
45	var_dump($mybv);
46}
47
48OCICommit($c);
49
50$stmtarray = array(
51    "drop sequence myseq",
52    "drop table mytab"
53);
54
55oci8_test_sql_execute($c, $stmtarray);
56
57echo "Done\n";
58?>
59--EXPECT--
60string(1) "1"
61string(1) "2"
62string(1) "3"
63string(1) "4"
64string(1) "5"
65string(1) "6"
66string(1) "7"
67string(1) "8"
68string(1) "9"
69string(2) "10"
70string(2) "11"
71string(2) "12"
72string(2) "13"
73string(2) "14"
74string(2) "15"
75string(2) "16"
76string(2) "17"
77string(2) "18"
78string(2) "19"
79string(2) "20"
80string(2) "21"
81string(2) "22"
82string(2) "23"
83string(2) "24"
84string(2) "25"
85string(2) "26"
86string(2) "27"
87string(2) "28"
88string(2) "29"
89string(2) "30"
90string(2) "31"
91string(2) "32"
92string(2) "33"
93string(2) "34"
94string(2) "35"
95string(2) "36"
96string(2) "37"
97string(2) "38"
98string(2) "39"
99string(2) "40"
100string(2) "41"
101string(2) "42"
102string(2) "43"
103string(2) "44"
104string(2) "45"
105string(2) "46"
106string(2) "47"
107string(2) "48"
108string(2) "49"
109string(2) "50"
110string(2) "51"
111string(2) "52"
112string(2) "53"
113string(2) "54"
114string(2) "55"
115string(2) "56"
116string(2) "57"
117string(2) "58"
118string(2) "59"
119string(2) "60"
120string(2) "61"
121string(2) "62"
122string(2) "63"
123string(2) "64"
124string(2) "65"
125string(2) "66"
126string(2) "67"
127string(2) "68"
128string(2) "69"
129string(2) "70"
130string(2) "71"
131string(2) "72"
132string(2) "73"
133string(2) "74"
134string(2) "75"
135string(2) "76"
136string(2) "77"
137string(2) "78"
138string(2) "79"
139string(2) "80"
140string(2) "81"
141string(2) "82"
142string(2) "83"
143string(2) "84"
144string(2) "85"
145string(2) "86"
146string(2) "87"
147string(2) "88"
148string(2) "89"
149string(2) "90"
150string(2) "91"
151string(2) "92"
152string(2) "93"
153string(2) "94"
154string(2) "95"
155string(2) "96"
156string(2) "97"
157string(2) "98"
158string(2) "99"
159string(2) "10"
160string(2) "10"
161string(2) "10"
162string(2) "10"
163string(2) "10"
164string(2) "10"
165string(2) "10"
166string(2) "10"
167string(2) "10"
168string(2) "10"
169string(2) "11"
170string(2) "11"
171string(2) "11"
172string(2) "11"
173string(2) "11"
174string(2) "11"
175string(2) "11"
176string(2) "11"
177string(2) "11"
178string(2) "11"
179string(2) "12"
180string(2) "12"
181string(2) "12"
182string(2) "12"
183string(2) "12"
184string(2) "12"
185string(2) "12"
186string(2) "12"
187string(2) "12"
188string(2) "12"
189string(2) "13"
190string(2) "13"
191string(2) "13"
192string(2) "13"
193string(2) "13"
194string(2) "13"
195string(2) "13"
196string(2) "13"
197string(2) "13"
198string(2) "13"
199string(2) "14"
200string(2) "14"
201string(2) "14"
202string(2) "14"
203string(2) "14"
204string(2) "14"
205string(2) "14"
206string(2) "14"
207string(2) "14"
208string(2) "14"
209string(2) "15"
210string(2) "15"
211string(2) "15"
212string(2) "15"
213string(2) "15"
214string(2) "15"
215string(2) "15"
216string(2) "15"
217string(2) "15"
218string(2) "15"
219string(2) "16"
220string(2) "16"
221string(2) "16"
222string(2) "16"
223string(2) "16"
224string(2) "16"
225string(2) "16"
226string(2) "16"
227string(2) "16"
228string(2) "16"
229string(2) "17"
230string(2) "17"
231string(2) "17"
232string(2) "17"
233string(2) "17"
234string(2) "17"
235string(2) "17"
236string(2) "17"
237string(2) "17"
238string(2) "17"
239string(2) "18"
240string(2) "18"
241string(2) "18"
242string(2) "18"
243string(2) "18"
244string(2) "18"
245string(2) "18"
246string(2) "18"
247string(2) "18"
248string(2) "18"
249string(2) "19"
250string(2) "19"
251string(2) "19"
252string(2) "19"
253string(2) "19"
254string(2) "19"
255string(2) "19"
256string(2) "19"
257string(2) "19"
258string(2) "19"
259Done
260