ID: 33564 Comment by: ait_ajkdak at yahoo 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:
When using software products with graphical interfaces, we frequently focus so much on the details of how to use the interface that we forget about the general concepts that allow us to understand and use the software effectively. This is particularly true of a powerful database product like Microsoft Access. Novice, and sometimes even experienced, programmers are so concerned with how something is done in Access that they often lose sight of the general principles that underlie their database applications. Access Database Design and Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications.1212121272381723461278934629378462937429329341 When using software products with graphical interfaces, we frequently focus so much on the details of how to use the interface that we forget about the general concepts that allow us to understand and use the software effectively. This is particularly true of a powerful database product like Microsoft Access. Novice, and sometimes even experienced, programmers are so concerned with how something is done in Access that they often lose sight of the general principles that underlie their database applications. Access Database Design and Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications.1212121272381723461278934629378462937429329341 When using software products with graphical interfaces, we frequently focus so much on the details of how to use the interface that we forget about the general concepts that allow us to understand and use the software effectively. This is particularly true of a powerful database product like Microsoft Access. Novice, and sometimes even experienced, programmers are so concerned with how something is done in Access that they often lose sight of the general principles that underlie their database applications. Access Database Design and Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications.1212121272381723461278934629378462937429329341 When using software products with graphical interfaces, we frequently focus so much on the details of how to use the interface that we forget about the general concepts that allow us to understand and use the software effectively. This is particularly true of a powerful database product like Microsoft Access. Novice, and sometimes even experienced, programmers are so concerned with how something is done in Access that they often lose sight of the general principles that underlie their database applications. Access Database Design and Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effect Previous Comments: ------------------------------------------------------------------------ [2008-03-16 18:12:04] phpnet at rosenthaltechnologies dot com 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 ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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