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