note 36035 added to function.ocinewdescriptor

Just a note. When INSERTing a CLOB, if a VALUES clause is used, Oracle notes: You cannot initialize an internal LOB attribute in an object with a value other than empty or null. That is, you cannot use a literal. That's why all the examples here INSERT an EMPTY_CLOB(), and use RETURNING to grab the pointer. However, a CLOB can also be INSERTed via a SELECT statement, and that won't require any descriptors. Example: $Clob = Str_Replace("'", "''", $Clob); OCIParse($DB, "INSERT INTO My_Table (My_Clob) SELECT '$Clob' FROM Dual"); This, of course, allows the use of a WHERE clause as well. ---- Manual Page -- http://www.php.net/manual/en/function.ocinewdescriptor.php Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+36035 Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+36035&report=yes Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+36035&report=yes