Lines Matching refs:s

48     $s = oci_parse($c, "select $colname from bind_misccoltypes_tab where id = :id");
49 oci_bind_by_name($s, ":id", $id);
50 oci_execute($s);
51 oci_fetch_all($s, $r);
108 $s = oci_parse($c, $insert_sql);
109 oci_bind_by_name($s, ":n1", $n1);
110 oci_bind_by_name($s, ":c1", $c1);
111 oci_bind_by_name($s, ":c2", $c2);
112 oci_bind_by_name($s, ":c3", $c3);
113 oci_bind_by_name($s, ":n2", $n2);
114 oci_bind_by_name($s, ":n3", $n3);
115 oci_bind_by_name($s, ":n4", $n4);
116 oci_bind_by_name($s, ":d1", $d1);
117 oci_bind_by_name($s, ":n5", $n5);
118 oci_bind_by_name($s, ":c4", $c4);
119 oci_bind_by_name($s, ":c5", $c5);
120 oci_bind_by_name($s, ":c6", $c6);
122 oci_execute($s);
145 $s = oci_parse($c, $select_sql);
147 oci_define_by_name($s, "ID", $ID);
148 oci_define_by_name($s, "CHAR_T", $CHAR_T);
149 oci_define_by_name($s, "CHAR_T10", $CHAR_T10);
150 oci_define_by_name($s, "VARCHAR2_T10", $VARCHAR2_T10);
151 oci_define_by_name($s, "NUMBER_T", $NUMBER_T);
152 oci_define_by_name($s, "NUMBER_T92", $NUMBER_T92);
153 oci_define_by_name($s, "NUMBER_T6", $NUMBER_T6);
154 oci_define_by_name($s, "DATE_T", $DATE_T);
155 oci_define_by_name($s, "TIMESTAMP_T", $TIMESTAMP_T);
156 oci_define_by_name($s, "FLOAT_T", $FLOAT_T);
157 oci_define_by_name($s, "BINARY_FLOAT_T", $BINARY_FLOAT_T);
158 oci_define_by_name($s, "BINARY_DOUBLE_T", $BINARY_DOUBLE_T);
159 oci_define_by_name($s, "DECIMAL_T", $DECIMAL_T);
160 oci_define_by_name($s, "INTEGER_T", $INTEGER_T);
161 oci_define_by_name($s, "NCHAR_T", $NCHAR_T);
162 oci_define_by_name($s, "NVARCHAR2_T10", $NVARCHAR2_T10);
163 oci_define_by_name($s, "VARCHAR_T10", $VARCHAR_T10);
165 oci_execute($s);
167 while (oci_fetch($s)) {
189 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t92) VALUES (52, :n1)");
191 oci_bind_by_name($s, ":n1", $n1);
192 oci_execute($s);
199 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t92) VALUES (53, :n1)");
201 oci_bind_by_name($s, ":n1", $n1);
202 oci_execute($s);
209 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t) VALUES (54, :n1)");
211 oci_bind_by_name($s, ":n1", $n1);
212 oci_execute($s);
218 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t) VALUES (55, :n1)");
220 oci_bind_by_name($s, ":n1", $n1);
221 oci_execute($s);
229 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, number_t) VALUES (56, :n1)");
230 oci_bind_by_name($s, ":n1", $n1);
231 oci_execute($s);
237 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, varchar2_t10) VALUES (58, :c2)");
239 oci_bind_by_name($s, ":c2", $c2);
240 oci_execute($s);
246 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, char_t10) VALUES (59, :c2)");
248 oci_bind_by_name($s, ":c2", $c2);
249 oci_execute($s);
255 $s = oci_parse($c, "INSERT INTO bind_misccoltypes_tab (id, date_t) VALUES (60, to_date(:c2, 'YYYY-M…
257 oci_bind_by_name($s, ":c2", $c2);
258 oci_execute($s);