Skip Menu |
 

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 34806
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: champoux [...] pythian.com
Requestors: dhorne [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 1.20
Fixed in: 1.28



Subject: Test fails t/26exe_array fails
Download (untitled) / with headers
text/plain 432b
This is on Centos 5 (RHEL 5), Oracle 11.1.0.6.0 t/26exe_array.............2/14 # Failed test '... we should have 19 tuple_status' # at t/26exe_array.t line 120. # got: 10 # expected: 19 # Failed test '... we should have 48 rows' # at t/26exe_array.t line 146. # got: 30 # expected: 48 # Looks like you failed 2 tests of 14. t/26exe_array............. Dubious, test returned 2 (wstat 512, 0x200)
Download (untitled) / with headers
text/plain 448b
Ok I will have to look into this. The problem being that there are not many Oracle 11 boxes out there yet. I will be getting one soon I hope. This also might be cause by the test user not having sufficient privs on the system you might want to try the make tests again with a user that has full System privs, Though this is a long shot. This also might be a bug in Oracle to boot. Do you know which Oracle Client you are using to connect?
Download (untitled) / with headers
text/plain 417b
Finally was able to test on an 11.1.06 box and I think I uncovered a bug in Oracle seems the OCIStmtExecute, with a mode (IN) of OCI_BATCH_ERRORS OCI_COMMIT_ON_SUCCESS (or 160) will always rollback where in 9~10 oracle it would commit the good inserts. Have written to Oracle on this and will have to wait for a reply you can follow this thread http://forums.oracle.com/forums/thread.jspa?threadID=682237
Download (untitled) / with headers
text/plain 182b
Seems this is a permissions and or size of buffer problem. 11g out of the box may fail some setup is required. What exatly I know not. I have sucessfully tested it on an 11g box
Download (untitled) / with headers
text/plain 213b
Seems this was an error in the 26exe_array.t itself and not DBD Oracle. It has been corrected in 1.28 you can get the corrected test here http://cpansearch.perl.org/src/PYTHIAN/DBD-Oracle-1.28/t/26exe_array.t


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.