Fwd: [perl #40331] Installation of DBD 1.18

---------- Forwarded message ----------
From: Juan Carlos Garc=EDa via RT
Date: Sep 13, 2006 4:47 AM
Subject: [perl #40331] Installation of DBD 1.18
To: "of perl Ticket #40331\"" <"AdminCc>




Hi.
I'm triying to install the latest version of the DBD module. But I
have problems. However, with the 1.16 version, all works ok.
Next, I put the result of the make test:

# make test
PERL_DL_NONLAZY=3D1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................ok
t/10general.............ok
t/15nls.................ok
t/20select..............ok
t/21nchar............... Database and client versions and character sets:
Database 9.2.0.4.0 CHAR set is WE8ISO8859P1 (Non-Unicode), NCHAR set
is AL16UTF16 (Unicode)
Client 9.2.0.4 NLS_LANG is '', NLS_NCHAR is ''
t/21nchar...............ok
t/22nchar_al32utf8......ok
t/22nchar_utf8..........ok
t/23wide_db.............skipped
all skipped: Database character set is not Unicode
t/23wide_db_8bit........skipped
all skipped: Database character set is not Unicode
t/23wide_db_al32utf8....skipped
all skipped: Database character set is not Unicode
t/24implicit_utf8.......ok
t/25plsql...............ok
t/26exe_array...........ok 1/13DBD::Oracle::st execute_array warning:
ORA-24381: error(s) in array DML (DBD SUCCESS_WITH_INFO: error
possibly near <*> indicator at char 66 in 'INSERT INTO
dbd_ora__drop_me ( row_1, row_2, row_3) VALUES (:p1,:<*>p2,:p3)')
[for Statement "INSERT INTO dbd_ora__drop_me ( row_1, row_2, row_3)
VALUES (?,?,?)" with ParamValues: :p3=3Dundef, :p1=3Dundef, :p2=3Dundef] at
t/26exe_array.t line 77.
t/26exe_array...........ok
t/30long................ok
122/470 skipped: various reasons
t/31lob.................ok 1/9DBD::Oracle::db selectrow_array failed:
ORA-00942: table or view does not exist (DBD ERROR: error possibly
near <*> indicator at char 103 in '
SELECT cache_lobs + nocache_lobs AS temp_lob_count
FROM v$temporary_lobs templob,
<*>v$session sess
WHERE sess.sid =3D templob.sid
AND sess.audsid =3D userenv('sessionid') ') [for Statement "
SELECT cache_lobs + nocache_lobs AS temp_lob_count
FROM v$temporary_lobs templob,
v$session sess
WHERE sess.sid =3D templob.sid
AND sess.audsid =3D userenv('sessionid') "] at t/31lob.t line 58.

# Failed test 'no temp lobs left'
t/31lob.................NOK 9# in t/31lob.t at line 166.
# got: undef
# expected: '0'

# Looks like you failed 1 test of 9.
t/31lob.................dubious
Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 9
Failed 1/9 tests, 88.89% okay
t/40ph_type.............ok 1/19 Placeholder behaviour for ora_type=3D1
(the default) varies with Oracle version.
Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
Your system doesn't. If that seems odd, let us know.
t/40ph_type.............ok
t/50cursor..............ok
t/55nested..............ok
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................ok

Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ ---------------=
----
t/31lob.t 1 256 9 1 11.11% 9
4 tests and 122 subtests skipped.
Failed 1/20 test scripts, 95.00% okay. 1/934 subtests failed, 99.89% okay.
make: *** [test_dynamic] Error 29

Thanks in advance for any idea.

Re: Fwd: [perl #40331] Installation of DBD 1.18

I had exactly this problem seen below. The cause was lack of
permissions. The user you are accessing your database as (by default it
will be scott/tiger) must have read permissions on the system tables
like v$session.

The rest are warnings and don't seem to matter.

Regards, K.

On Wed, 2006-09-13 at 11:03 -0300, Adriano Ferreira wrote:
> ---------- Forwarded message ----------
> From: Juan Carlos García via RT
> Date: Sep 13, 2006 4:47 AM
> Subject: [perl #40331] Installation of DBD 1.18
> To: "of perl Ticket #40331\"" <"AdminCc>
>=20
>=20
>
>=20
> Hi.
> I'm triying to install the latest version of the DBD module. But I
> have problems. However, with the 1.16 version, all works ok.
> Next, I put the result of the make test:
>=20
> # make test
> PERL_DL_NONLAZY=3D1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
> "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> t/01base................ok
> t/10general.............ok
> t/15nls.................ok
> t/20select..............ok
> t/21nchar............... Database and client versions and character sets:
> Database 9.2.0.4.0 CHAR set is WE8ISO8859P1 (Non-Unicode), NCHAR set
> is AL16UTF16 (Unicode)
> Client 9.2.0.4 NLS_LANG is '', NLS_NCHAR is ''
> t/21nchar...............ok
> t/22nchar_al32utf8......ok
> t/22nchar_utf8..........ok
> t/23wide_db.............skipped
> all skipped: Database character set is not Unicode
> t/23wide_db_8bit........skipped
> all skipped: Database character set is not Unicode
> t/23wide_db_al32utf8....skipped
> all skipped: Database character set is not Unicode
> t/24implicit_utf8.......ok
> t/25plsql...............ok
> t/26exe_array...........ok 1/13DBD::Oracle::st execute_array warning:
> ORA-24381: error(s) in array DML (DBD SUCCESS_WITH_INFO: error
> possibly near <*> indicator at char 66 in 'INSERT INTO
> dbd_ora__drop_me ( row_1, row_2, row_3) VALUES (:p1,:<*>p2,:p3)')
> [for Statement "INSERT INTO dbd_ora__drop_me ( row_1, row_2, row_3)
> VALUES (?,?,?)" with ParamValues: :p3=3Dundef, :p1=3Dundef, :p2=3Dundef] =
at
> t/26exe_array.t line 77.
> t/26exe_array...........ok
> t/30long................ok
> 122/470 skipped: various reasons
> t/31lob.................ok 1/9DBD::Oracle::db selectrow_array failed:
> ORA-00942: table or view does not exist (DBD ERROR: error possibly
> near <*> indicator at char 103 in '
> SELECT cache_lobs + nocache_lobs AS temp_lob_count
> FROM v$temporary_lobs templob,
> <*>v$session sess
> WHERE sess.sid =3D templob.sid
> AND sess.audsid =3D userenv('sessionid') ') [for Statement "
> SELECT cache_lobs + nocache_lobs AS temp_lob_count
> FROM v$temporary_lobs templob,
> v$session sess
> WHERE sess.sid =3D templob.sid
> AND sess.audsid =3D userenv('sessionid') "] at t/31lob.t line 58.
>=20
> # Failed test 'no temp lobs left'
> t/31lob.................NOK 9# in t/31lob.t at line 166.
> # got: undef
> # expected: '0'
>=20
> # Looks like you failed 1 test of 9.
> t/31lob.................dubious
> Test returned status 1 (wstat 256, 0x100)
> DIED. FAILED test 9
> Failed 1/9 tests, 88.89% okay
> t/40ph_type.............ok 1/19 Placeholder behaviour for ora_type=3D1
> (the default) varies with Oracle version.
> Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
> Your system doesn't. If that seems odd, let us know.
> t/40ph_type.............ok
> t/50cursor..............ok
> t/55nested..............ok
> t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
> skipped
> all skipped: no reason given
> t/70meta................ok
>=20
> Failed Test Stat Wstat Total Fail Failed List of Failed
> ------------------------------------------------------------ -------------=
------
> t/31lob.t 1 256 9 1 11.11% 9
> 4 tests and 122 subtests skipped.
> Failed 1/20 test scripts, 95.00% okay. 1/934 subtests failed, 99.89% okay=
..
> make: *** [test_dynamic] Error 29
>=20
> Thanks in advance for any idea.
--=20
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~
Karl Auer (kauer@biplane.com.au) +61-2-64957160 (h)
http://www.biplane.com.au/~kauer/ +61-428-957160 (mob)

Re: [perl #40331] Installation of DBD 1.18

I take it the Maketest result is from DBD::Oracle 1.18

If this is the case then

1) the error in t/26exe_array is expected (it is testing how errors are
handled) is it is not an erro
2) the error in t/31lob is cause when the user does not have
permission/space or whatever to create a lob cache. Check with you DB admin
on which lob permission you have on the tables

# 2 is only a problem if you plan to use lobs.

Cheers
John Scoles









----- Original Message -----
From: "Adriano Ferreira"
To:
Sent: Wednesday, September 13, 2006 10:03 AM
Subject: Fwd: [perl #40331] Installation of DBD 1.18


---------- Forwarded message ----------
From: Juan Carlos García via RT
Date: Sep 13, 2006 4:47 AM
Subject: [perl #40331] Installation of DBD 1.18
To: "of perl Ticket #40331\"" <"AdminCc>




Hi.
I'm triying to install the latest version of the DBD module. But I
have problems. However, with the 1.16 version, all works ok.
Next, I put the result of the make test:

# make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................ok
t/10general.............ok
t/15nls.................ok
t/20select..............ok
t/21nchar............... Database and client versions and character sets:
Database 9.2.0.4.0 CHAR set is WE8ISO8859P1 (Non-Unicode), NCHAR set
is AL16UTF16 (Unicode)
Client 9.2.0.4 NLS_LANG is '', NLS_NCHAR is ''
t/21nchar...............ok
t/22nchar_al32utf8......ok
t/22nchar_utf8..........ok
t/23wide_db.............skipped
all skipped: Database character set is not Unicode
t/23wide_db_8bit........skipped
all skipped: Database character set is not Unicode
t/23wide_db_al32utf8....skipped
all skipped: Database character set is not Unicode
t/24implicit_utf8.......ok
t/25plsql...............ok
t/26exe_array...........ok 1/13DBD::Oracle::st execute_array warning:
ORA-24381: error(s) in array DML (DBD SUCCESS_WITH_INFO: error
possibly near <*> indicator at char 66 in 'INSERT INTO
dbd_ora__drop_me ( row_1, row_2, row_3) VALUES (:p1,:<*>p2,:p3)')
[for Statement "INSERT INTO dbd_ora__drop_me ( row_1, row_2, row_3)
VALUES (?,?,?)" with ParamValues: :p3=undef, :p1=undef, :p2=undef] at
t/26exe_array.t line 77.
t/26exe_array...........ok
t/30long................ok
122/470 skipped: various reasons
t/31lob.................ok 1/9DBD::Oracle::db selectrow_array failed:
ORA-00942: table or view does not exist (DBD ERROR: error possibly
near <*> indicator at char 103 in '
SELECT cache_lobs + nocache_lobs AS temp_lob_count
FROM v$temporary_lobs templob,
<*>v$session sess
WHERE sess.sid = templob.sid
AND sess.audsid = userenv('sessionid') ') [for Statement "
SELECT cache_lobs + nocache_lobs AS temp_lob_count
FROM v$temporary_lobs templob,
v$session sess
WHERE sess.sid = templob.sid
AND sess.audsid = userenv('sessionid') "] at t/31lob.t line 58.

# Failed test 'no temp lobs left'
t/31lob.................NOK 9# in t/31lob.t at line 166.
# got: undef
# expected: '0'

# Looks like you failed 1 test of 9.
t/31lob.................dubious
Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 9
Failed 1/9 tests, 88.89% okay
t/40ph_type.............ok 1/19 Placeholder behaviour for ora_type=1
(the default) varies with Oracle version.
Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
Your system doesn't. If that seems odd, let us know.
t/40ph_type.............ok
t/50cursor..............ok
t/55nested..............ok
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................ok

Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ -------------------
t/31lob.t 1 256 9 1 11.11% 9
4 tests and 122 subtests skipped.
Failed 1/20 test scripts, 95.00% okay. 1/934 subtests failed, 99.89% okay.
make: *** [test_dynamic] Error 29

Thanks in advance for any idea.