ID: 33564
Updated by: [EMAIL PROTECTED]
Reported By: daniel at bitarts dot com
-Status: Open
+Status: Assigned
Bug Type: OCI8 related
Operating System: solaris
PHP Version: 5.0.4
-Assigned To:
+Assigned To: tony2001
Previous Comments:
------------------------------------------------------------------------
[2005-07-05 16:53:00] daniel at bitarts dot com
I had made a mistake, TRANSLATE only works for NVARCHAR's etc and
anything less than 2000 characaters.
What I should be using is TO_NCHAR. This works fine in sql:
UPDATE TEST
SET NCLOB_BACKUP = TO_NCLOB(:NCLOB_BACKUP)
WHERE ID='4
However, running this through php causes php to lock up:
$data = "TEst2";
$lob = OCINewDescriptor($conn, OCI_D_LOB);
$stmt = OCIParse($conn,"UPDATE TEST
SET NCLOB_BACKUP =
TO_NCLOB(:NCLOB_BACKUP)
WHERE ID='4'");
OCIBindByName($stmt, ':NCLOB_BACKUP', &$lob, -1, OCI_B_CLOB);
$lob->WriteTemporary($data);
OCIExecute($stmt, OCI_DEFAULT);
$lob->close();
$lob->free();
OCICommit($conn);
I'm not too sure if it is an oracle bug anymore, or if it is, php
should respond to it better?
Thanks
------------------------------------------------------------------------
[2005-07-05 11:35:20] [EMAIL PROTECTED]
Or some kind of your mistake, I'm not sure how to classify it.
So it doesn't look like PHP-only problem and I'm closing this report as
bogus. Feel free to reopen it if/when you have more info.
------------------------------------------------------------------------
[2005-07-05 11:23:34] daniel at bitarts dot com
Same things happens there too, when I add lots of characters. Seems to
be a bug in oracle?
------------------------------------------------------------------------
[2005-07-04 22:24:47] [EMAIL PROTECTED]
And what if you try to do the same with SQLPlus?
Do the same query work for you?
------------------------------------------------------------------------
[2005-07-04 16:20:41] daniel at bitarts dot com
I am using Oracle 9i
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/33564
--
Edit this bug report at http://bugs.php.net/?id=33564&edit=1
