> + my $ora_server_version = $dbh->func("ora_server_version");
> + if ($ora_server_version < 10) {
> + ok(0, 1, 1); # skip
The INTERVAL datatype was introduced in 9i - in which case perhaps this
should be "< 9.2" ?
Also regarding:
--- oci8.c.orig 2005-06-06 10:31:38.000000000 +0200
+++ oci8.c 2005-06-06 10:35:29.000000000 +0200
@@ -1207,6 +1207,7 @@
case 182: /* INTERVAL YEAR TO MONTH */
case 183: /* INTERVAL DAY TO SECOND */
+ case 190: /* INTERVAL DAY TO SECOND */
case 187: /* TIMESTAMP */
case 188: /* TIMESTAMP WITH TIME ZONE */
case 232: /* TIMESTAMP WITH LOCAL TIME ZONE */
For completeness shouldn't that also then include:
+ case 189: /* INTERVAL YEAR TO MONTH descriptor */
as per:
http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96584/oci03typ.h
tm#421821
... and a similar test using TO_YMINTERVAL?
--
Andy Hassall <[EMAIL PROTECTED]> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>