ID: 33564
Comment by: phpnet at rosenthaltechnologies dot com
Reported By: daniel at bitarts dot com
Status: No Feedback
Bug Type: OCI8 related
Operating System: solaris
PHP Version: 5.0.4
Assigned To: tony2001
New Comment:
I'm getting the same error with oci9... (when I try to save an nclob it
locks up). what is the status of nclob support in oci9?
Best,
Brian
Previous Comments:
------------------------------------------------------------------------
[2005-09-16 01:00:02] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2005-09-08 11:52:03] [EMAIL PROTECTED]
Please try OCI8 v.1.1, which is available in CVS HEAD and PECL (use
`pear install oci8-beta` to install it).
------------------------------------------------------------------------
[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?
------------------------------------------------------------------------
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
