Lines Matching refs:stmt
37 function bindvar($stmt, $name, $var)
39 oci_bind_by_name($stmt, $name, $var);
48 $stmt = oci_parse($c, $sql);
50 bindvar($stmt, ':var1', $cache1);
51 bindvar($stmt, ':var2', $cache2);
53 oci_execute($stmt);
55 var_dump(oci_fetch_assoc($stmt));
57 oci_free_statement($stmt);
65 $stmt = oci_parse($c, $sql);
67 bindvar($stmt, ':output1', $cache1);
68 bindvar($stmt, ':output2', $cache2);
70 oci_execute($stmt);
75 oci_free_statement($stmt);
83 $stmt = oci_parse($c, $sql);
85 oci_bind_by_name($stmt, ":output1", $cache1);
86 oci_bind_by_name($stmt, ":output2", $cache2);
88 oci_execute($stmt);
93 oci_free_statement($stmt);
101 $stmt = oci_parse($c, $sql);
103 oci_bind_by_name($stmt, ":var1", $cache1, -1);
104 oci_bind_by_name($stmt, ":var2", $cache2, -1);
105 oci_bind_by_name($stmt, ":output", $cache3, 100);
107 oci_execute($stmt);
119 $stmt = oci_parse($c, $sql);
121 bindvar($stmt, ':var1', $cache1);
122 bindvar($stmt, ':var2', $cache2);
123 bindvar($stmt, ':var3', $cache3);
125 oci_execute($stmt);
131 oci_free_statement($stmt);
141 $stmt = oci_parse($c, $sql);
143 oci_bind_by_name($stmt, ":var1", $cache1, -1);
144 oci_bind_by_name($stmt, ":var2", $cache2, -1);
145 oci_bind_by_name($stmt, ":var3", $cache3, 100);
147 oci_execute($stmt);