[PHP] CLOB update difficulties

[Chris Murtland]

Hello,

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);

However, this gives me the error: invalid LOB locator specified.

Any suggestions would be greatly appreciated.

Thanks,
Chris

~~~~~~~~~~~~~~~~~~~~
Chris Murtland
Studio Moxie, LLC
www.studiomoxie.com
336.773.1684
800.707.2367 fax/voicemail


-- 
PHP General 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]