/PHP-8.0/ext/oci8/tests/ |
H A D | bind_sqltint.phpt | 28 oci_bind_by_name($s, ":id", $id); 40 oci_bind_by_name($s, ":c2", $c2, -1, SQLT_INT); 131 oci_bind_by_name($s, ":p1", $p1, 10); 140 oci_bind_by_name($s, ":p1", $p1, 10); 149 oci_bind_by_name($s, ":p1", $p1, 10); 158 oci_bind_by_name($s, ":p1", $p1, 10); 167 oci_bind_by_name($s, ":p1", $p1, 10); 176 oci_bind_by_name($s, ":p1", $p1, 10); 185 oci_bind_by_name($s, ":p1", $p1, 10); 194 oci_bind_by_name($s, ":p1", $p1, 10); [all …]
|
H A D | bind_char_3.phpt | 34 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2); 42 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); 51 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10); 61 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10, SQL… 99 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10, SQL… 107 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); 117 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10); 147 $r = oci_bind_by_name($s, ':bv1', $bv1, 0, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 0, SQLT_… 157 $r = oci_bind_by_name($s, ':bv1', $bv1, 1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 1, SQLT_… 178 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); [all …]
|
H A D | bind_char_3_11gR1.phpt | 34 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2); 42 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); 51 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10); 61 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10, SQL… 99 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10, SQL… 107 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); 117 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10); 147 $r = oci_bind_by_name($s, ':bv1', $bv1, 0, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 0, SQLT_… 157 $r = oci_bind_by_name($s, ':bv1', $bv1, 1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 1, SQLT_… 178 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); [all …]
|
H A D | bind_char_4.phpt | 36 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2); 44 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); 53 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10); 63 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10, SQL… 101 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10, SQL… 109 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); 119 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10); 149 $r = oci_bind_by_name($s, ':bv1', $bv1, 0, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 0, SQLT_… 159 $r = oci_bind_by_name($s, ':bv1', $bv1, 1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 1, SQLT_… 180 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); [all …]
|
H A D | bind_char_4_11gR1.phpt | 36 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2); 44 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); 53 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10); 63 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10, SQL… 101 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10, SQL… 109 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); 119 $r = oci_bind_by_name($s, ':bv1', $bv1, -1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 10); 149 $r = oci_bind_by_name($s, ':bv1', $bv1, 0, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 0, SQLT_… 159 $r = oci_bind_by_name($s, ':bv1', $bv1, 1, SQLT_AFC) && oci_bind_by_name($s, ':bv2', $bv2, 1, SQLT_… 180 $r = oci_bind_by_name($s, ':bv1', $bv1) && oci_bind_by_name($s, ':bv2', $bv2, 10); [all …]
|
H A D | bind_unsupported_1.phpt | 30 oci_bind_by_name($s, ":c1", $c1, -1, $v); 37 Warning: oci_bind_by_name(): Unknown or unsupported datatype given: 97 in %sbind_unsupported_1.php … 40 Warning: oci_bind_by_name(): Unknown or unsupported datatype given: 5 in %sbind_unsupported_1.php o… 43 Warning: oci_bind_by_name(): Unknown or unsupported datatype given: 9 in %sbind_unsupported_1.php o… 46 Warning: oci_bind_by_name(): Unknown or unsupported datatype given: 94 in %sbind_unsupported_1.php … 49 Warning: oci_bind_by_name(): Unknown or unsupported datatype given: 4 in %sbind_unsupported_1.php o… 52 Warning: oci_bind_by_name(): Unknown or unsupported datatype given: 68 in %sbind_unsupported_1.php … 55 Warning: oci_bind_by_name(): Unknown or unsupported datatype given: 156 in %sbind_unsupported_1.php…
|
H A D | bind_sqltafc.phpt | 41 oci_bind_by_name($s, ":c2", $c2, -1, SQLT_AFC); 42 oci_bind_by_name($s, ":c3", $c3, -1, SQLT_AFC); 43 oci_bind_by_name($s, ":c4", $c4, -1, SQLT_AFC); 44 oci_bind_by_name($s, ":c5", $c5, -1, SQLT_AFC); 56 oci_bind_by_name($s, ":c2", $c2, -1, SQLT_AFC); 57 oci_bind_by_name($s, ":c3", $c3, -1, SQLT_AFC); 58 oci_bind_by_name($s, ":c4", $c4, -1, SQLT_AFC); 59 oci_bind_by_name($s, ":c5", $c5, -1, SQLT_AFC); 71 oci_bind_by_name($s, ":c2", $c2, -1, SQLT_AFC); 72 oci_bind_by_name($s, ":c3", $c3, -1, SQLT_AFC); [all …]
|
H A D | refcur_prefetch_4.phpt | 58 oci_bind_by_name($s,':c1',$i); 59 oci_bind_by_name($s,':c2',$val2); 71 die("oci_bind_by_name(sql1) failed!\n"); 80 die("oci_bind_by_name(sql2) failed!\n"); 82 if (!oci_bind_by_name($s2, ":c1", $c1, -1, SQLT_INT)) { 83 die("oci_bind_by_name(sql2) failed!\n"); 86 die("oci_bind_by_name(sql2) failed!\n"); 94 die("oci_bind_by_name(sql2) failed!\n"); 104 die("oci_bind_by_name(sql1) failed!\n"); 115 die("oci_bind_by_name(sql1) failed!\n"); [all …]
|
H A D | bind_char_1.phpt | 2 SELECT oci_bind_by_name with SQLT_AFC aka CHAR 40 $r = oci_bind_by_name($s, ":bv", $bv1); 45 $r = oci_bind_by_name($s, ":bv", $bv1, -1, SQLT_AFC); 50 $r = oci_bind_by_name($s, ":bv", $bv1, 0, SQLT_AFC); 75 $r = oci_bind_by_name($s, ":bv", $bv1); 80 $r = oci_bind_by_name($s, ":bv", $bv1, -1, SQLT_AFC); 85 $r = oci_bind_by_name($s, ":bv", $bv1, 0, SQLT_AFC); 111 $r = oci_bind_by_name($s, ":bv", $bv1); 121 $r = oci_bind_by_name($s, ":bv", $bv1, 0, SQLT_AFC); 147 $r = oci_bind_by_name($s, ":bv", $bv1); [all …]
|
H A D | bind_char_1_11gR1.phpt | 2 SELECT oci_bind_by_name with SQLT_AFC aka CHAR 42 $r = oci_bind_by_name($s, ":bv", $bv1); 47 $r = oci_bind_by_name($s, ":bv", $bv1, -1, SQLT_AFC); 52 $r = oci_bind_by_name($s, ":bv", $bv1, 0, SQLT_AFC); 77 $r = oci_bind_by_name($s, ":bv", $bv1); 82 $r = oci_bind_by_name($s, ":bv", $bv1, -1, SQLT_AFC); 87 $r = oci_bind_by_name($s, ":bv", $bv1, 0, SQLT_AFC); 113 $r = oci_bind_by_name($s, ":bv", $bv1); 123 $r = oci_bind_by_name($s, ":bv", $bv1, 0, SQLT_AFC); 149 $r = oci_bind_by_name($s, ":bv", $bv1); [all …]
|
H A D | bind_misccoltypes.phpt | 106 oci_bind_by_name($s, ":n1", $n1); 107 oci_bind_by_name($s, ":c1", $c1); 108 oci_bind_by_name($s, ":c2", $c2); 109 oci_bind_by_name($s, ":c3", $c3); 110 oci_bind_by_name($s, ":n2", $n2); 111 oci_bind_by_name($s, ":n3", $n3); 112 oci_bind_by_name($s, ":n4", $n4); 113 oci_bind_by_name($s, ":d1", $d1); 114 oci_bind_by_name($s, ":n5", $n5); 115 oci_bind_by_name($s, ":c4", $c4); [all …]
|
H A D | bind_unsupported_3.phpt | 26 oci_bind_by_name($s, ":c1", $c1, -1, $v); 33 Warning: oci_bind_by_name(): Unable to find descriptor property in %sbind_unsupported_3.php on line… 36 Warning: oci_bind_by_name(): Unable to find descriptor property in %sbind_unsupported_3.php on line… 39 Warning: oci_bind_by_name(): Unable to find descriptor property in %sbind_unsupported_3.php on line… 42 Warning: oci_bind_by_name(): Unable to find descriptor property in %sbind_unsupported_3.php on line…
|
H A D | bug72524.phpt | 30 oci_bind_by_name($stmt, ':clob_col', $clob); 31 oci_bind_by_name($stmt, ':varchar2_col', $varchar2); 39 oci_bind_by_name($stmt, ':clob_col', $clob); 40 oci_bind_by_name($stmt, ':varchar2_col', $varchar2); 47 oci_bind_by_name($stmt, ':clob_col', $clob, 0); 48 oci_bind_by_name($stmt, ':varchar2_col', $varchar2, 0); 55 oci_bind_by_name($stmt, ':clob_col', $clob, -1, SQLT_LNG); 56 oci_bind_by_name($stmt, ':varchar2_col', $varchar2, -1, SQLT_LNG); 63 oci_bind_by_name($stmt, ':clob_col', $clob, 0, SQLT_LNG); 64 oci_bind_by_name($stmt, ':varchar2_col', $varchar2, 0, SQLT_LNG);
|
H A D | bind_boolean_1.phpt | 31 oci_bind_by_name($s, ':output1', $output1, -1, OCI_B_BOL); 32 oci_bind_by_name($s, ':output2', $output2, -1, OCI_B_BOL); 42 oci_bind_by_name($s, ':b', $b, -1, OCI_B_BOL); 58 oci_bind_by_name($s, ':output', $output, -1, OCI_B_BOL); 60 oci_bind_by_name($s, ':input', $input); 76 oci_bind_by_name($s, ':b', $b, -1, OCI_B_BOL); 78 oci_bind_by_name($s, ':userid', $userid, -1, SQLT_INT); 97 oci_bind_by_name($s, ':b1', $b1, -1, OCI_B_BOL); 98 oci_bind_by_name($s, ':b2', $b2, -1, OCI_B_BOL);
|
H A D | bind_sqltchr_1.phpt | 28 oci_bind_by_name($s, ":id", $id); 40 oci_bind_by_name($s, ":c2", $c2, -1, SQLT_CHR); 50 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_CHR); 59 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_CHR); 68 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_CHR); 77 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_CHR); 86 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_CHR); 95 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_CHR); 104 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_CHR); 113 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_CHR); [all …]
|
H A D | bind_sqltnum.phpt | 33 oci_bind_by_name($s, ":id", $id); 46 $r = oci_bind_by_name($s, ":c2", $c2, -1); 81 oci_bind_by_name($s, ":c2", $c2, -1, SQLT_NUM); 88 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); 97 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); 106 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); 115 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); 124 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); 133 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); 142 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); [all …]
|
H A D | bind_sqltnum_11g.phpt | 33 oci_bind_by_name($s, ":id", $id); 46 $r = oci_bind_by_name($s, ":c2", $c2, -1); 81 oci_bind_by_name($s, ":c2", $c2, -1, SQLT_NUM); 88 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); 97 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); 106 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); 115 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); 124 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); 133 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); 142 oci_bind_by_name($s, ":n1", $n1, -1, SQLT_NUM); [all …]
|
H A D | refcur_prefetch_2.phpt | 56 oci_bind_by_name($s,':c1',$i); 57 oci_bind_by_name($s,':c2',$val2); 68 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) { 69 die("oci_bind_by_name(sql1) failed!\n"); 78 die("oci_bind_by_name(sql2) failed!\n"); 80 if (!oci_bind_by_name($s2, ":c1", $c1, -1, SQLT_INT)) { 81 die("oci_bind_by_name(sql2) failed!\n"); 83 if (!oci_bind_by_name($s2, ":c2", $c2, 20, SQLT_CHR)) { 84 die("oci_bind_by_name(sql2) failed!\n"); 113 die("oci_bind_by_name(sql1) failed!\n"); [all …]
|
H A D | bind_number.phpt | 33 oci_bind_by_name($s, ":id", $id); 45 oci_bind_by_name($s, ":n1", $n1); 54 oci_bind_by_name($s, ":f1", $f1); 63 oci_bind_by_name($s, ":f1", $f1); 72 oci_bind_by_name($s, ":f1", $f1); 81 oci_bind_by_name($s, ":f1", $f1); 90 oci_bind_by_name($s, ":f1", $f1, -1, SQLT_NUM); 99 oci_bind_by_name($s, ":f1", $f1); 108 oci_bind_by_name($s, ":f1", $f1); 117 oci_bind_by_name($s, ":f1", $f1, -1, SQLT_INT);
|
H A D | bind_char_2.phpt | 2 SELECT oci_bind_by_name with SQLT_AFC aka CHAR and dates 37 $r = oci_bind_by_name($s, ":bv", $bv1); 42 $r = oci_bind_by_name($s, ":bv", $bv1, -1, SQLT_AFC); 47 $r = oci_bind_by_name($s, ":bv", $bv1, 0, SQLT_AFC); 52 $r = oci_bind_by_name($s, ":bv", $bv1, strlen($bv1), SQLT_AFC); 57 $r = oci_bind_by_name($s, ":bv", $bv1, strlen($bv1)-1, SQLT_AFC); 62 $r = oci_bind_by_name($s, ":bv", $bv1, strlen($bv1)+1, SQLT_AFC);
|
H A D | bind_char_2_11gR1.phpt | 2 SELECT oci_bind_by_name with SQLT_AFC aka CHAR and dates 37 $r = oci_bind_by_name($s, ":bv", $bv1); 42 $r = oci_bind_by_name($s, ":bv", $bv1, -1, SQLT_AFC); 47 $r = oci_bind_by_name($s, ":bv", $bv1, 0, SQLT_AFC); 52 $r = oci_bind_by_name($s, ":bv", $bv1, strlen($bv1), SQLT_AFC); 57 $r = oci_bind_by_name($s, ":bv", $bv1, strlen($bv1)-1, SQLT_AFC); 62 $r = oci_bind_by_name($s, ":bv", $bv1, strlen($bv1)+1, SQLT_AFC);
|
H A D | error_bind.phpt | 2 Test some oci_bind_by_name error conditions 23 oci_bind_by_name($stmt, ":name", $name, 10, SQLT_CHR); 31 oci_bind_by_name($stmt, ":name", $c); 38 oci_bind_by_name($stmt, ":r_id", $c); 59 Warning: oci_bind_by_name(): Invalid variable used for bind in %s on line %d 66 Warning: oci_bind_by_name(): Invalid variable used for bind in %s on line %d
|
H A D | bug38161.phpt | 2 Bug #38161 (oci_bind_by_name() returns garbage when Oracle didn't set the variable) 12 oci_bind_by_name($stid, ":bv", $bv, 22); 20 oci_bind_by_name($stid, ":bv", $bv, 22, SQLT_INT);
|
H A D | bind_unsupported_2.phpt | 23 oci_bind_by_name($s, ":c1", $c1, -1, $v); 30 Warning: oci_bind_by_name(): Unknown or unsupported datatype given: 22 in %sbind_unsupported_2.php … 33 Warning: oci_bind_by_name(): Unknown or unsupported datatype given: 21 in %sbind_unsupported_2.php …
|
H A D | bind_empty.phpt | 23 oci_bind_by_name($stmt, ":name", $name); 31 oci_bind_by_name($stmt, ":name", $name); 45 oci_bind_by_name($stmt, ":name", $name); 58 oci_bind_by_name($stmt, ":name", $name); 71 oci_bind_by_name($s, ":bv", $bv); 80 oci_bind_by_name($s, ":bv", $bv);
|