":body" in sql isn't the same as ":bodytext" in the bindbyname statement,
after that, you're in deeper than myself...
HTH,
-Joe
""Chris Murtland"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I apologize for my cross-post, but since I received no response on the
> general list, I decided I must have posted in the wrong place.
>
> 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.
>
> 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.
>
> Thanks in advance,
> Chris
>
> ~~~~~~~~~~~~~~~~~~~~
> Chris Murtland
> Studio Moxie, LLC
> www.studiomoxie.com
> 336.773.1684
> 800.707.2367 fax/voicemail
>
>
> --
> 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]
>
--
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]
