diff options
Diffstat (limited to 'ext/oci8/tests/bind_char_4_11gR1.phpt')
| -rw-r--r-- | ext/oci8/tests/bind_char_4_11gR1.phpt | 60 |
1 files changed, 30 insertions, 30 deletions
diff --git a/ext/oci8/tests/bind_char_4_11gR1.phpt b/ext/oci8/tests/bind_char_4_11gR1.phpt index 51350e533e..e40887c450 100644 --- a/ext/oci8/tests/bind_char_4_11gR1.phpt +++ b/ext/oci8/tests/bind_char_4_11gR1.phpt @@ -22,7 +22,7 @@ require(__DIR__.'/connect.inc'); // Initialization $stmtarray = array( - "create or replace function bind_char_3_fn(p1 varchar2) return varchar2 as begin return p1; end;", + "create or replace function bind_char_3_fn(p1 varchar2) return varchar2 as begin return p1; end;", ); oci8_test_sql_execute($c, $stmtarray); @@ -35,7 +35,7 @@ $s = oci_parse($c, "begin :bv2 := bind_char_3_fn(:bv1); end;"); $bv1 = 'abc'; $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); echo "Test 1.2 In Length: default. In Type: default. Out Length: 10. Out Type: default\n"; @@ -43,7 +43,7 @@ echo "Test 1.2 In Length: default. In Type: default. Out Length: 10. $bv1 = 'abc'; $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -52,7 +52,7 @@ echo "Test 1.3 In Length: -1. In Type: AFC. Out Length: 10. $bv1 = 'abc'; $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -62,7 +62,7 @@ echo "Test 1.4 In Length: -1. In Type: AFC. Out Length: 10. $bv1 = 'abc'; $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10, SQLT_AFC); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -71,7 +71,7 @@ echo "Test 1.5 In Length: strlen. In Type: AFC. Out Length: strlen(input) $bv1 = 'abc'; $r = oci_bind_by_name($s, ':bv1', $bv1, strlen($bv1), SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, strlen($bv1), SQLT_AFC); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -80,7 +80,7 @@ echo "Test 1.6 In Length: strlen. In Type: AFC. Out Length: strlen(input) $bv1 = 'abc'; $r = oci_bind_by_name($s, ':bv1', $bv1, strlen($bv1), SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, strlen($bv1)-1, SQLT_AFC); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -89,7 +89,7 @@ echo "Test 1.7 In Length: strlen. In Type: AFC. Out Length: strlen(input) $bv1 = 'abc'; $r = oci_bind_by_name($s, ':bv1', $bv1, strlen($bv1), SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, strlen($bv1)+1, SQLT_AFC); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -100,7 +100,7 @@ echo "Test 2.1 In Length: -1. In Type: AFC. Out Length: 10. $bv1 = ''; $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10, SQLT_AFC); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -108,7 +108,7 @@ echo "Test 2.2 In Length: default. In Type: default. Out Length: 10. $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -118,7 +118,7 @@ echo "Test 2.3 In Length: -1. In Type: AFC. Out Length: 10. $bv1 = ''; $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -128,7 +128,7 @@ echo "Test 2.4 In Length: -1. In Type: AFC. Out Length: 10. $bv1 = ''; $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10, SQLT_AFC); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -138,7 +138,7 @@ echo "Test 2.5 In Length: -1. In Type: AFC. Out Length: 0. $bv1 = ''; $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 0, SQLT_AFC); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -148,7 +148,7 @@ echo "Test 2.6 In Length: 0. In Type: AFC. Out Length: 0. $bv1 = ''; $r = oci_bind_by_name($s, ':bv1', $bv1, 0, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 0, SQLT_AFC); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -158,7 +158,7 @@ echo "Test 2.7 In Length: 1. In Type: AFC. Out Length: 1. $bv1 = ''; $r = oci_bind_by_name($s, ':bv1', $bv1, 1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 1, SQLT_AFC); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -170,7 +170,7 @@ echo "Test 3.1 In Length: -1. In Type: AFC. Out Length: 10. $bv1 = null; $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10, SQLT_AFC); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -179,7 +179,7 @@ echo "Test 3.2 In Length: default. In Type: default. Out Length: 10. $bv1 = null; $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -189,7 +189,7 @@ echo "Test 3.3 In Length: -1. In Type: AFC. Out Length: 10. $bv1 = null; $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -199,7 +199,7 @@ echo "Test 3.4 In Length: -1. In Type: AFC. Out Length: 10. $bv1 = null; $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10, SQLT_AFC); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -208,7 +208,7 @@ echo "Test 3.5 In Length: -1. In Type: AFC. Out Length: 0. $bv1 = null; $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 0, SQLT_AFC); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); @@ -218,26 +218,26 @@ echo "Test 3.6 In Length: -1. In Type: AFC. Out Length: 1. $bv1 = null; $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 1, SQLT_AFC); if ($r) - do_e($s); + do_e($s); var_dump($bv1, $bv2); function do_e($s) { - echo " Executing:\n"; - - $r = @oci_execute($s); - if (!$r) { - $m = oci_error($s); - echo " Oci_execute error ORA-".$m['code']."\n"; - return; - } + echo " Executing:\n"; + + $r = @oci_execute($s); + if (!$r) { + $m = oci_error($s); + echo " Oci_execute error ORA-".$m['code']."\n"; + return; + } } // Cleanup $stmtarray = array( - "drop function bind_char_3_fn" + "drop function bind_char_3_fn" ); oci8_test_sql_execute($c, $stmtarray); |