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

History Show all quoted text
  Wed Apr 09 22:48:46 2008 dhorne [...] cpan.org - Ticket created
Subject: Test fails t/26exe_array fails
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)
  Fri Apr 25 10:48:55 2008 champoux [...] pythian.com - Taken
  Fri Apr 25 10:52:39 2008 champoux [...] pythian.com - Correspondence added
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?
  Fri Apr 25 10:53:05 2008 The RT System itself - Status changed from 'new' to 'open'
  Tue Jul 15 12:37:41 2008 champoux [...] pythian.com - Correspondence added
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
  Tue Jul 15 12:37:50 2008 champoux [...] pythian.com - Status changed from 'open' to 'stalled'
  Thu Apr 30 12:41:08 2009 champoux [...] pythian.com - Correspondence added
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
  Thu Apr 30 12:41:10 2009 The RT System itself - Status changed from 'stalled' to 'open'
  Thu Apr 30 12:41:12 2009 champoux [...] pythian.com - Status changed from 'open' to 'resolved'
  Tue Dec 21 18:51:44 2010 champoux [...] pythian.com - Status changed from 'resolved' to 'open'
  Mon Mar 21 08:01:25 2011 champoux [...] pythian.com - Correspondence added
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
  Thu Mar 24 06:33:10 2011 bohica [...] ntlworld.com - Status changed from 'open' to 'resolved'
  Thu Mar 24 06:33:11 2011 bohica [...] ntlworld.com - Fixed in 1.28 added