note 20605 added to function.ocinewdescriptor
| From: | sozturk at emediamillworks dot com | Date: | Tue, 09 Apr 2002 19:30:23 +0000 |
| Subject: | note 20605 added to function.ocinewdescriptor | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-29027@lists.php.net to get a copy of this message | ||
I had the same problem with updating the lobs with shorter content as in one of the notes above. The
addition of "\0" at the end of the replacement text didn't help either. But the
following worked perfectly:
$sql = "UPDATE sometable SET lob_col = EMPTY_LOB() WHERE key_col = $key RETURNING lob_col INTO
:lob";
$stmt = OCIParse($conn,$sql);
$lob = OCINewDescriptor($conn,OCI_D_LOB);
OCIBindByName($stmt,':lob',&$lob,-1,OCI_B_BLOB);
OCIExecute($stmt,OCI_DEFAULT);
$lob->save($sometext);
$lob->free();
--
http://www.php.net/manual/en/function.ocinewdescriptor.php
http://master.php.net/manage/user-notes.php?action=edit+20605
http://master.php.net/manage/user-notes.php?action=delete+20605
http://master.php.net/manage/user-notes.php?action=reject+20605