#33564 [Opn->Asn]: Strange behaviour passing long string to TRANSLATE in oracle

ID: 33564 Updated by: sniper@php.net 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] tony2001@php.net 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] tony2001@php.net 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