#33564 [Com]: Strange behaviour passing long string to TRANSLATE in oracle

2008-06-03 Thread ait_ajkdak at yahoo dot com
 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->

#33564 [Com]: Strange behaviour passing long string to TRANSLATE in oracle

2008-03-16 Thread phpnet at rosenthaltechnologies dot com
 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