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: 81317
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: (no value)



Subject: 34pres_lobs.t: Data Interface for Persistent LOBs new in Oracle 9
Data Interface for Persistent LOBs is new in Oracle 9, so I'd skip these tests for older versions. Patch attached. FYI, Oracle server v8 and client v10 throw ORA-00932: inconsistent datatypes: expected CHAR got CLOB for the SELECT statements.
Subject: 34pres_lobs.diff
Index: t/34pres_lobs.t =================================================================== --- t/34pres_lobs.t (revision 15482) +++ t/34pres_lobs.t (working copy) @@ -31,6 +31,8 @@ AutoCommit=>1, PrintError => 0 ,LongReadLen=>10000000})}; if ($dbh) { + plan skip_all => "Data Interface for Persistent LOBs new in Oracle 9" + if $dbh->func('ora_server_version')->[0] < 9; plan tests => 29; } else { plan skip_all => "Unable to connect to Oracle";
On Wed Nov 21 04:15:58 2012, SGOELDNER wrote: Show quoted text
> Data Interface for Persistent LOBs is new in Oracle 9, so I'd skip these > tests for older versions. > Patch attached. > > FYI, Oracle server v8 and client v10 throw > > ORA-00932: inconsistent datatypes: expected CHAR got CLOB > > for the SELECT statements.
Thanks, patch applied to subversion trunk. I've not got Oracle 8 or 10 and I didn't write those tests. Perhaps I can find someone to look into the ORA 00932. Martin -- Martin J. Evans Wetherby, UK
Martin could you close this please?