summaryrefslogtreecommitdiff
path: root/ext/oci8/tests/bind_char_4.phpt
diff options
context:
space:
mode:
Diffstat (limited to 'ext/oci8/tests/bind_char_4.phpt')
-rw-r--r--ext/oci8/tests/bind_char_4.phpt19
1 files changed, 10 insertions, 9 deletions
diff --git a/ext/oci8/tests/bind_char_4.phpt b/ext/oci8/tests/bind_char_4.phpt
index 7377604b0..40221b266 100644
--- a/ext/oci8/tests/bind_char_4.phpt
+++ b/ext/oci8/tests/bind_char_4.phpt
@@ -5,14 +5,17 @@ PL/SQL oci_bind_by_name with SQLT_AFC aka CHAR to VARCHAR2 parameter
if (!extension_loaded('oci8')) die ("skip no oci8 extension");
require(dirname(__FILE__)."/connect.inc");
$sv = oci_server_version($c);
-$sv = preg_match('/Release 1[12]\./', $sv, $matches);
+$sv = preg_match('/Release 1[01]\.2\./', $sv, $matches);
if ($sv !== 1) {
- die ("skip expected output only valid when using Oracle 11g+ database");
+ die ("skip expected output only valid when using Oracle 10gR2 or 11gR2 databases");
}
?>
--FILE--
<?php
+// Note: expected output is valid for 32bit clients to 32bit 10gR2 XE or 11.2.0.1 64bit DBs.
+// It will diff on the undefined cases with a 32bit 11.2.0.1 DB
+
// Same test as bind_char_3 but the PL/SQL function uses VARCHAR2 instead of CHAR
require(dirname(__FILE__).'/connect.inc');
@@ -256,9 +259,8 @@ echo "Done\n";
--EXPECTF--
Test 1.1 In Length: default. In Type: default. Out Length: default. Out Type: default
Executing:
- Oci_execute error ORA-6502
string(3) "abc"
-NULL
+string(3) "abc"
Test 1.2 In Length: default. In Type: default. Out Length: 10. Out Type: default
Executing:
string(3) "abc"
@@ -270,20 +272,19 @@ string(3) "abc"
Test 1.4 In Length: -1. In Type: AFC. Out Length: 10. Out Type: AFC
Executing:
string(3) "abc"
-string(10) "abc "
+string(30) "abc "
Test 1.5 In Length: strlen. In Type: AFC. Out Length: strlen(input). Out Type: AFC
Executing:
string(3) "abc"
-string(3) "abc"
+string(9) "abc "
Test 1.6 In Length: strlen. In Type: AFC. Out Length: strlen(input)-1. Out Type: AFC
Executing:
- Oci_execute error ORA-6502
-string(3) "abc"
string(3) "abc"
+string(6) "abc "
Test 1.7 In Length: strlen. In Type: AFC. Out Length: strlen(input)+1. Out Type: AFC
Executing:
string(3) "abc"
-string(4) "abc "
+string(12) "abc "
Tests with ''