Re: [PHP4BETA] LOB support for oci8 broken ?

Andreas Jung wrote: > > Hi, > > I tried the following (according to the documentation) > to insert a LOB into an O8i table with a CLOB field "inhalt": > > #!/ojs/home/ora8/tmp/php > <? > > $conn = OCILogon("dummy","dummy","fulltext"); > $stmt = OCIParse($conn,"insert into fulltext (docnum,inhalt) > values('blabla',:mb ) "); > > $clob = OCINewDescriptor($conn, OCI_D_LOB); > OCIBindByName($stmt,':mb',&$clob,-1,OCI_B_CLOB); > > $s=""; > for ($i=0;$i<2000;$i++) $s.="x"; > > OCIExecute($stmt,OCI_DEFAULT); > if($clob->save($s)) OCICommit($conn); > else echo "clob problem"; > > OCIFreeStatement($stmt); > > OCILogoff($conn); > > ?> Try the following: (Yes, Oracle LOB support is ahm ...) <? ... $clob = OCINewDescriptor($conn, OCI_D_LOB); $stmt = OCIParse($conn,"insert into fulltext (docnum,inhalt) values('blabla', EMPTY_BLOB()) returning inhalt into :mb"); OCIBindByName($stmt,':mb',&$clob,-1,OCI_B_CLOB); $s=""; ... ?> -Andreas -- Andreas Karajannis GMD National Research Center for Information Technology Schloss Birlinghoven, D-53754 Sankt Augustin Phone +49 2241 142948