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: 80704
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: Nobody in particular
Requestors: sgoeldner [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: 1.56



Subject: 51scroll.t: Scrollable cursors new in Oracle 9
Download (untitled) / with headers
text/plain 715b
Scrollable cursors are new in Oracle 9, so I'd skip these tests for older versions. Patch attached. Interestingly, running the test with Oracle8 fails, but shows an ORA-00000. Only with trace enabled, we see the more helpful error 24391: OCIStmtExecute (6a527f4,6a5a848,6a528a8,0,0,0,0,mode=STMT_SCROLLABLE_READONLY,8)=ERROR OCIAttrGet (6a5a848,OCI_HTYPE_STMT,22f73e,0,OCI_ATTR_PARSE_ERROR_OFFSET,6a528a8)=SU CCESS OCIErrorGet(6a528a8,1,"<NULL>",22f6ec,"ORA-00000: normal, successful completion ",1024,2)=SUCCESS OCIErrorGet after error possibly near <*> indicator at char 14 in 'select * from <*>dbd_ora__drop_me' (er1:ok): -1, 24391: ORA-00000: normal, successful completion
Subject: 51scroll.diff
Download 51scroll.diff
text/x-diff 522b
Index: t/51scroll.t =================================================================== --- t/51scroll.t (revision 15465) +++ t/51scroll.t (working copy) @@ -24,6 +24,8 @@ AutoCommit=>1, PrintError => 0 })}; if ($dbh) { + plan skip_all => "Scrollable cursors new in Oracle 9" + if $dbh->func('ora_server_version')->[0] < 9; plan tests => 36; } else { plan skip_all => "Unable to connect to Oracle";
Download (untitled) / with headers
text/plain 880b
On Thu Nov 08 09:00:35 2012, SGOELDNER wrote: Show quoted text
> Scrollable cursors are new in Oracle 9, so I'd skip these tests for > older versions. > Patch attached. > > Interestingly, running the test with Oracle8 fails, but shows an > ORA-00000. > Only with trace enabled, we see the more helpful error 24391: > > OCIStmtExecute > (6a527f4,6a5a848,6a528a8,0,0,0,0,mode=STMT_SCROLLABLE_READONLY,8)=ERROR > OCIAttrGet > (6a5a848,OCI_HTYPE_STMT,22f73e,0,OCI_ATTR_PARSE_ERROR_OFFSET,6a528a8)=SU > CCESS > OCIErrorGet(6a528a8,1,"<NULL>",22f6ec,"ORA-00000: normal, > successful completion > ",1024,2)=SUCCESS > OCIErrorGet after error possibly near <*> indicator at char 14 > in 'select * from <*>dbd_ora__drop_me' (er1:ok): -1, 24391: ORA-00000: > normal, successful completion
Thank you. applied to subversion trunk. Martin -- Martin J. Evans Wetherby, UK


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.