note 20605 added to function.ocinewdescriptor

From: 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

« previous php.notes (#29027) next »