On Thu, Oct 21, 2004 at 02:44:35PM +0200, Silvio Wanka wrote:
> >>Do you think that the successfully tested post 1.16-rc7 version is usable
> >>in the meantime in a production environment or should I wait for the
> >>released 1.16.
> >
> >If this works for you then yes:
> >  http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc8-20041019.tar.gz
> 
> HP-UX 10.20 Oracle 8.0.6 (client and server), perl 5.6.1:
> All tests successful, 8 tests and 128 subtests skipped.
> 
> HP-UX 11.00 Oracle 8.1.7 (client and server), perl 5.6.1:
> All tests successful, 8 tests and 128 subtests skipped.
> 
> But both only with the following workaround:
> 
> --- 25plsql.t~  Tue Oct 19 18:06:40 2004
> +++ 25plsql.t   Thu Oct 21 14:25:01 2004
> @@ -317,2 +317,3 @@
>     my $sth = $dbh->prepare(qq{SELECT $func_name(?, ?) FROM DUAL});
> +    $sth or skip("Can't prepare ($DBI::errstr)", 16);
>     ok(0, $sth);
> 
> The demons of too many of character sets strikes back ;-).
> Here are the outputs and logs without workaround:

And here's a patch (currently untested).

Tim.


Index: t/25plsql.t
===================================================================
--- t/25plsql.t (revision 506)
+++ t/25plsql.t (working copy)
@@ -314,8 +314,12 @@
          end if;
        END;
     }) or skip("Can't create a function ($DBI::errstr)", 16);
-    my $sth = $dbh->prepare(qq{SELECT $func_name(?, ?) FROM DUAL});
-    ok(0, $sth);
+    my $sth = $dbh->prepare(qq{SELECT $func_name(?, ?) FROM DUAL}, {
+       # Oracle 8 describe fails with ORA-06553: PLS-561: charset mismatch
+       ora_check_sql => 0,
+    });
+    ok(0, $sth, "Can't prepare select from function ($DBI::errstr)");
+    skip("Can't select from function ($DBI::errstr)", 15) unless $sth;
     ok(0, $sth->bind_columns(\my $returnVal));
     for (1..2) {
        ok(0, $sth->bind_param(1, "foo", { ora_csform => SQLCS_NCHAR }));

Reply via email to