Lines Matching refs:c
21 function sessionid($c) // determines and returns current session ID
25 $stmt = oci_parse($c, $query);
36 function templobs($c, $sid) // returns number of temporary LOBs
40 $stmt = oci_parse($c, $query);
53 function readxmltab_ex($c)
55 $stmt = oci_parse($c, "select extract(xml, '/').getclobval() from bug43497_tab");
68 function readxmltab_ex_nofree($c)
70 $stmt = oci_parse($c, "select extract(xml, '/').getclobval() from bug43497_tab");
82 function readxmltab_im($c)
84 $stmt = oci_parse($c, "select extract(xml, '/').getclobval() from bug43497_tab");
95 function createxmltab($c) // create table w/ field of XML type
97 @dropxmltab($c);
98 $stmt = oci_parse($c, "create table bug43497_tab (id number primary key, xml xmltype)");
102 function dropxmltab($c) // delete table
104 $stmt = oci_parse($c, "drop table bug43497_tab");
109 function fillxmltab($c)
126 …$stmt = oci_parse($c, "insert into bug43497_tab(id, xml) values (:id, sys.xmltype.createxml(:xml))…
128 $clob = oci_new_descriptor($c, OCI_D_LOB);
141 createxmltab($c);
142 fillxmltab($c);
146 $sid = sessionid($c);
151 echo "Temporary LOBs = " . templobs($c, $sid) . "\n";
152 readxmltab_ex($c);
158 echo "Temporary LOBs = " . templobs($c, $sid) . "\n";
159 readxmltab_im($c);
165 echo "Temporary LOBs = " . templobs($c, $sid) . "\n";
166 readxmltab_ex_nofree($c);
173 dropxmltab($c);
175 oci_close($c);