lob_null.phpt - OpenGrok cross reference for /PHP-7.4/ext/oci8/tests/lob

Lines Matching refs:s
15 $s = oci_parse($c, 'drop table lob_null_tab');
16 @oci_execute($s);
18 $s = oci_parse($c, 'create table lob_null_tab (id number, data clob)');
19 oci_execute($s);
21 $s = oci_parse($c,
26 oci_execute($s);
28 $s = oci_parse($c,
33 oci_execute($s);
38 $s = oci_parse($c, "insert into lob_null_tab values (1, :b)");
40 oci_bind_by_name($s, ':b', $lob, -1, OCI_B_CLOB);
42 $r = @oci_execute($s);
44     $m = oci_error($s);
52 $s = oci_parse($c, "insert into lob_null_tab values (2, :b)");
54 oci_bind_by_name($s, ':b', $lob, -1, OCI_B_CLOB);
56 $r = @oci_execute($s);
58     $m = oci_error($s);
66 $s = oci_parse($c, "insert into lob_null_tab values (3, :b)");
68 oci_bind_by_name($s, ':b', $lob, -1, OCI_B_CLOB);
70 $r = @oci_execute($s);
72     $m = oci_error($s);
82 $s = oci_parse($c, "call lob_null_proc_in(4, :b)");
84 oci_bind_by_name($s, ':b', $lob, -1, OCI_B_CLOB);
86 $r = @oci_execute($s);
88     $m = oci_error($s);
96 $s = oci_parse($c, "call lob_null_proc_in(5, :b)");
98 oci_bind_by_name($s, ':b', $lob, -1, OCI_B_CLOB);
100 $r = @oci_execute($s);
102     $m = oci_error($s);
110 $s = oci_parse($c, "call lob_null_proc_in(6, :b)");
112 oci_bind_by_name($s, ':b', $lob, -1, OCI_B_CLOB);
114 $r = @oci_execute($s);
116     $m = oci_error($s);
126 $s = oci_parse($c, "insert into lob_null_tab values (7, empty_clob()) returning data into :b");
128 oci_bind_by_name($s, ':b', $lob, -1, OCI_B_CLOB);
129 oci_execute($s, OCI_DEFAULT);  // Must have OCI_DEFAULT here so locator is still valid
133 $s = oci_parse($c, "insert into lob_null_tab values (8, empty_clob()) returning data into :b");
135 oci_bind_by_name($s, ':b', $lob, -1, OCI_B_CLOB);
136 oci_execute($s, OCI_DEFAULT);  // Must have OCI_DEFAULT here so locator is still valid
140 $s = oci_parse($c, "insert into lob_null_tab values (9, empty_clob()) returning data into :b");
142 oci_bind_by_name($s, ':b', $lob, -1, OCI_B_CLOB);
143 oci_execute($s, OCI_DEFAULT);  // Must have OCI_DEFAULT here so locator is still valid
147 $s = oci_parse ($c, 'select id, data from lob_null_tab order by id');
148 oci_execute($s);
149 oci_fetch_all($s, $res);
153 $s = oci_parse ($c, 'select id, data from lob_null_tab order by id');
154 oci_execute($s);
155 while ($arr = oci_fetch_assoc($s)) {
169     $s = oci_parse ($c, "call lob_null_proc_out($i, :b)");
171     oci_bind_by_name($s, ':b', $lob, -1, OCI_B_CLOB);
172     oci_execute($s);
185 $s = oci_parse($c, 'drop table lob_null_tab');
186 @oci_execute($s);