Tim Bunce wrote:
On Wed, Oct 20, 2004 at 02:53:43PM +0200, Silvio Wanka wrote:

PS. When DBD::Oracle 1.16 will be released?

When I find the time to slay the demons of too many permutations of client and server versions and character sets and Oracle, er, features.

I've not had the time (or the energy) recently while I've been trying to
progress DBI related issues. But I do plan to get back to it soon.

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

Tim.

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:

STDOUT/STDERR from test.pl
t/25plsql...........ok 65/83Can't call method "bind_columns" on an undefined value at 
t/25plsql.t line 319.
t/25plsql...........dubious

STDOUT/STDERR from 25plsql.t:
ok 61
test bind_param_inout of param that's not assigned to in executed statement
Before p1=[Hello] p2=[Y] p3=[Y]
ok 62
ok 63
ok 64
ok 65
After p1=[Hello] p2=[Y] p3=[Y]
test nvarchar2 arg passing to functions
# failed test 66 at line 318
not ok 66
Can't call method "bind_columns" on an undefined value at t/25plsql.t line 319.

trace.log:
   -> do for DBD::Oracle::db (DBI::db=HASH(0x405a4338)~0x405a9ea8 '
        CREATE OR REPLACE FUNCTION dbd_oracle_nvctest(arg nvarchar2, arg2 nvarchar2)
        RETURN int IS
        BEGIN
          if arg is null or arg2 is null then
             return -1;
          else
             return 1;
          end if;
        END;
   ')
1   -> prepare for DBD::Oracle::db (DBI::db=HASH(0x405a9ea8)~INNER '
        CREATE OR REPLACE FUNCTION dbd_oracle_nvctest(arg nvarchar2, arg2 nvarchar2)
        RETURN int IS
        BEGIN
          if arg is null or arg2 is null then
             return -1;
          else
             return 1;
          end if;
        END;
   ' undef)
   New DBI::st (for DBD::Oracle::st, parent=DBI::db=HASH(0x405a9ea8), id=)
   dbih_setup_handle(DBI::st=HASH(0x4060f158)=>DBI::st=HASH(0x4060f110), 
DBD::Oracle::st, 4060f188, Null!)
   dbih_make_com(DBI::db=HASH(0x405a9ea8), 4057f608, DBD::Oracle::st, 208, 00000000) 
thr#00000000
   dbd_st_prepare'd sql CREATE (pl1, auto_lob1, check_sql1)
   dbd_describe skipped for CREATE
1   <- prepare= DBI::st=HASH(0x4060f158) at DBI.pm line 1410 via 
/opt/perl5/v6s1/lib/share/perl5db.pl line 1483
   -> execute for DBD::Oracle::st (DBI::st=HASH(0x4060f158)~0x4060f110)
   dbd_st_execute CREATE (out0, lob0)...
   dbd_st_execute CREATE returned (SUCCESS, rpc0, fn91, out0)
   <- execute= '0E0' at DBI.pm line 1411 via /opt/perl5/v6s1/lib/share/perl5db.pl line 
1483
   -> rows for DBD::Oracle::st (DBI::st=HASH(0x4060f158)~0x4060f110)
   <- rows= 0 at DBI.pm line 1412 via /opt/perl5/v6s1/lib/share/perl5db.pl line 1483
   <> DESTROY ignored for outer handle DBI::st=HASH(0x4060f158) (inner 
DBI::st=HASH(0x4060f110) has ref cnt 1)
   -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x4060f110)~INNER)
   <- DESTROY= undef at perl5db.pl line 1487
   dbih_clearcom 0x4060f158 (com 0x405f6b08, type 3) done.

   <- do= '0E0' at 25plsql.t line 306
   -> prepare for DBD::Oracle::db (DBI::db=HASH(0x405a4338)~0x405a9ea8 'SELECT 
dbd_oracle_nvctest(?, ?) FROM DUAL')
   New DBI::st (for DBD::Oracle::st, parent=DBI::db=HASH(0x405a9ea8), id=)
   dbih_setup_handle(DBI::st=HASH(0x4060f14c)=>DBI::st=HASH(0x4060f1dc), 
DBD::Oracle::st, 4060f170, Null!)
   dbih_make_com(DBI::db=HASH(0x405a9ea8), 4057f608, DBD::Oracle::st, 208, 00000000) 
thr#00000000
   dbd_preparse scanned 2 distinct placeholders
   dbd_st_prepare'd sql SELECT (pl1, auto_lob1, check_sql1)
   dbd_describe SELECT (EXPLICIT, lb 80)...
   OCIErrorGet after error possibly near <*> indicator at char 7 in 'SELECT 
<*>dbd_oracle_nvctest(:p1, :p2) FROM DUAL' (er1:ok): -1, 6553: ORA-06553: PLS-561: character 
set mismatch on value for parameter 'ARG2'
ORA-06553: PLS-561: character set mismatch on value for parameter 'ARG'

   <> DESTROY ignored for outer handle DBI::st=HASH(0x4060f14c) (inner 
DBI::st=HASH(0x4060f1dc) has ref cnt 1)
   -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x4060f1dc)~INNER)
      ERROR: '6553' 'ORA-06553: PLS-561: character set mismatch on value for parameter 
'ARG2'
ORA-06553: PLS-561: character set mismatch on value for parameter 'ARG' (DBD ERROR: error possibly 
near <*> indicator at char 7 in 'SELECT <*>dbd_oracle_nvctest(:p1, :p2) FROM DUAL')' 
(err#1)
   <- DESTROY= undef at perl5db.pl line 1487
   dbih_clearcom 0x4060f14c (com 0x405f6a08, type 3) done.

   !! ERROR: '6553' 'ORA-06553: PLS-561: character set mismatch on value for parameter 
'ARG2'
ORA-06553: PLS-561: character set mismatch on value for parameter 'ARG' (DBD ERROR: error possibly 
near <*> indicator at char 7 in 'SELECT <*>dbd_oracle_nvctest(:p1, :p2) FROM DUAL')' 
(err#0)
   <- prepare= undef at 25plsql.t line 317
1   -> FETCH for DBD::Oracle::db (DBI::db=HASH(0x405a9ea8)~INNER 'ParamValues')
   .. FETCH DBI::db=HASH(0x405a9ea8) 'ParamValues' = undef
      ERROR: '6553' 'ORA-06553: PLS-561: character set mismatch on value for parameter 
'ARG2'
ORA-06553: PLS-561: character set mismatch on value for parameter 'ARG' (DBD ERROR: error possibly 
near <*> indicator at char 7 in 'SELECT <*>dbd_oracle_nvctest(:p1, :p2) FROM DUAL')' 
(err#0)
1   <- FETCH= undef at 25plsql.t line 317
   >> DESTROY DBI::db=HASH(0x405a9ea8) clearing 2 CachedKids
   <> DESTROY ignored for outer handle DBI::st=HASH(0x405abb14) (inner 
DBI::st=HASH(0x405ab934) has ref cnt 1)
   -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x405ab934)~INNER)
      ERROR: '6553' 'ORA-06553: PLS-561: character set mismatch on value for parameter 
'ARG2'
ORA-06553: PLS-561: character set mismatch on value for parameter 'ARG' (DBD ERROR: error possibly 
near <*> indicator at char 7 in 'SELECT <*>dbd_oracle_nvctest(:p1, :p2) FROM DUAL')' 
(err#0)
   <- DESTROY= undef
   dbih_clearcom 0x405abb14 (com 0x40598b08, type 3) done.

   <> DESTROY ignored for outer handle DBI::st=HASH(0x405f1f5c) (inner 
DBI::st=HASH(0x405f1f44) has ref cnt 1)
   -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x405f1f44)~INNER)
      ERROR: '6553' 'ORA-06553: PLS-561: character set mismatch on value for parameter 
'ARG2'
ORA-06553: PLS-561: character set mismatch on value for parameter 'ARG' (DBD ERROR: error possibly 
near <*> indicator at char 7 in 'SELECT <*>dbd_oracle_nvctest(:p1, :p2) FROM DUAL')' 
(err#0)
   <- DESTROY= undef
   dbih_clearcom 0x405f1f5c (com 0x40598a08, type 3) done.

   <> DESTROY ignored for outer handle DBI::db=HASH(0x405a4338) (inner 
DBI::db=HASH(0x405a9ea8) has ref cnt 5)
   <> DESTROY ignored for outer handle DBI::st=HASH(0x405a9f68) (inner 
DBI::st=HASH(0x405a9e90) has ref cnt 1)
   -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x405a9e90)~INNER)
      ERROR: '6553' 'ORA-06553: PLS-561: character set mismatch on value for parameter 
'ARG2'
ORA-06553: PLS-561: character set mismatch on value for parameter 'ARG' (DBD ERROR: error possibly 
near <*> indicator at char 7 in 'SELECT <*>dbd_oracle_nvctest(:p1, :p2) FROM DUAL')' 
(err#0)
   <- DESTROY= undef
   dbih_clearcom 0x405a9f68 (com 0x40560c08, type 3) done.

   <> DESTROY ignored for outer handle DBI::st=HASH(0x405ab94c) (inner 
DBI::st=HASH(0x405ab8c8) has ref cnt 1)
   -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x405ab8c8)~INNER)
      ERROR: '6553' 'ORA-06553: PLS-561: character set mismatch on value for parameter 
'ARG2'
ORA-06553: PLS-561: character set mismatch on value for parameter 'ARG' (DBD ERROR: error possibly 
near <*> indicator at char 7 in 'SELECT <*>dbd_oracle_nvctest(:p1, :p2) FROM DUAL')' 
(err#1)
   <- DESTROY= undef
   dbih_clearcom 0x405ab94c (com 0x40530f08, type 3) done.

   -> DESTROY for DBD::Oracle::db (DBI::db=HASH(0x405a9ea8)~INNER)
      ERROR: '6553' 'ORA-06553: PLS-561: character set mismatch on value for parameter 
'ARG2'
ORA-06553: PLS-561: character set mismatch on value for parameter 'ARG' (DBD ERROR: error possibly 
near <*> indicator at char 7 in 'SELECT <*>dbd_oracle_nvctest(:p1, :p2) FROM DUAL')' 
(err#0)
   <- DESTROY= undef
   dbih_clearcom 0x405a4338 (com 0x4057f608, type 2) done.

   -- DBI::END
   !! ERROR: '6553' CLEARED by call to disconnect_all method
   -> disconnect_all for DBD::Oracle::dr (DBI::dr=HASH(0x402f21dc)~0x405a435c)
   <- disconnect_all= (not implemented) at DBI.pm line 657 via 
/opt/perl5/v6s1/lib/share/perl5db.pl line 1483
!   -> DESTROY for DBD::Oracle::dr (DBI::dr=HASH(0x405a435c)~INNER)
!   <- DESTROY= (not implemented) during global destruction
   dbih_clearcom 0x402f21dc (com 0x405a2c88, type 1) done.

!   <> DESTROY for DBI::dr=HASH(0x402f21dc) ignored (inner handle gone)

regards, Silvio



Reply via email to