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 }));