| Subject: | 51scroll.t: Scrollable cursors new in Oracle 9 |
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 |
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";