xref: /PHP-7.0/ext/oci8/tests/bind_char_2.phpt (revision a52902fa)
1--TEST--
2SELECT oci_bind_by_name with SQLT_AFC aka CHAR and dates
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.
8preg_match('/.*Release ([[:digit:]]+)\.([[:digit:]]+)\.([[:digit:]]+)\.([[:digit:]]+)\.([[:digit:]]+)*/', oci_server_version($c), $matches);
9if (!(isset($matches[0]) && $matches[1] >= 12)) {
10    die("skip expected output only valid when using Oracle 12c database");
11}
12?>
13--ENV--
14NLS_LANG=.AL32UTF8
15--FILE--
16<?php
17
18require(dirname(__FILE__).'/connect.inc');
19
20// Initialization
21
22$stmtarray = array(
23	"alter session set nls_date_format='YYYY-MM-DD'",
24	"drop table bind_char_tab",
25	"create table bind_char_tab (id number, c1 date)",
26	"insert into bind_char_tab values (1, '2008-04-20')",
27);
28
29oci8_test_sql_execute($c, $stmtarray);
30
31// Run Test
32
33$bv1 = '2008-04-20';
34
35echo "Test 1.1: Type: default.  Length: default\n";
36$s = oci_parse($c, "select * from bind_char_tab where c1 = :bv");
37$r = oci_bind_by_name($s, ":bv", $bv1);
38if ($r)
39   do_e_q($s);
40
41echo "Test 1.2: Type: AFC.  Length: default\n";
42$r = oci_bind_by_name($s, ":bv", $bv1, -1, SQLT_AFC);
43if ($r)
44   	do_e_q($s);
45
46echo "Test 1.3: Type: AFC:  Length: 0\n";
47$r = oci_bind_by_name($s, ":bv", $bv1, 0, SQLT_AFC);
48if ($r)
49	do_e_q($s);
50
51echo "Test 1.4: Type: AFC:  Length: strlen\n";
52$r = oci_bind_by_name($s, ":bv", $bv1, strlen($bv1), SQLT_AFC);
53if ($r)
54	do_e_q($s);
55
56echo "Test 1.5: Type: AFC.  Length: strlen-1\n";
57$r = oci_bind_by_name($s, ":bv", $bv1, strlen($bv1)-1, SQLT_AFC);
58if ($r)
59	do_e_q($s);
60
61echo "Test 1.6: Type: AFC.  Length: strlen+1\n";
62$r = oci_bind_by_name($s, ":bv", $bv1, strlen($bv1)+1, SQLT_AFC);
63if ($r)
64	do_e_q($s);
65
66
67function do_e_q($s)
68{
69	echo "  Querying:\n";
70
71	$r = @oci_execute($s);
72	if (!$r) {
73		$m = oci_error($s);
74		echo "    Oci_execute error ORA-".$m['code']." Exiting Query\n";
75		return;
76	}
77	while ($row = oci_fetch_array($s, OCI_ASSOC+OCI_RETURN_NULLS)) {
78		foreach ($row as $item) {
79			echo "    :" . $item . ":\n";
80		}
81	}
82}
83
84// Cleanup
85$stmtarray = array(
86	"drop table bind_char_tab"
87);
88
89oci8_test_sql_execute($c, $stmtarray);
90
91echo "Done\n";
92
93?>
94--EXPECT--
95Test 1.1: Type: default.  Length: default
96  Querying:
97    :1:
98    :2008-04-20:
99Test 1.2: Type: AFC.  Length: default
100  Querying:
101    :1:
102    :2008-04-20:
103Test 1.3: Type: AFC:  Length: 0
104  Querying:
105    :1:
106    :2008-04-20:
107Test 1.4: Type: AFC:  Length: strlen
108  Querying:
109    :1:
110    :2008-04-20:
111Test 1.5: Type: AFC.  Length: strlen-1
112  Querying:
113Test 1.6: Type: AFC.  Length: strlen+1
114  Querying:
115    :1:
116    :2008-04-20:
117Done
118