Chris Murtland wrote:
> I am trying to update an Oracle 8i CLOB field. I have looked at
> previous messages on the list and am trying the following:
> $sql="update murtland.articles set
title='$title',release_date=TO_DATE('$release_date','YYYY-MM-DD'),body=:body
> text,sections='$sections',mod_date=TO_DATE('$mod_date','yyyy-mm-dd
> hh24:mi:ss'),mod_userid=$userid where articleid=$articleid";
> //echo $sql; $stmt=OCIParse($conn,$sql); $bodytext =
> OCINewDescriptor($conn, OCI_D_LOB);
> OCIBindByName($stmt,":bodytext",&$bodytext,-1,OCI_B_CLOB);
> OCIExecute($stmt, OCI_DEFAULT); $bodytext->save($body);
OCICommit($stmt);
> $bodytext->free(); OCIFreeStatement($stmt);
> OCILogoff($conn);
>
Try the following SQL:
"update ... , body = empty_clob(), ... returning body into :bodytext"
> Also, does anyone have any example code for searching Oracle 8i CLOB
> fields? Do I have to create a stored procedure to be able to do
> this? I want to be able to search a separate varchar column in
> addition to searching the CLOB column.
>
Try interMedia Text for searching B|CLOB columns. While stored
procedures could be used, they will be painfully slow.
-Andreas
--
Andreas Karajannis
mediaworx berlin AG
Fon (0 30) 2 75 80 - 266
Fax (0 30) 2 75 80 - 200
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
