Re: Oracle 8i questions

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