Re: ANNOUNCE: DBD::Oracle 1.22 Release Candidate 2

On Jul 28, 2008, at 18:06, John Scoles wrote:

> Ok hot off the press  RC2
>
> I have fixed as much as I can of the different compiler warnings  
> hopefully this will be a little better.
>
> You can find the RC here
>
>
> http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.22-RC2.tar
>

I tried it on our Linux build box and got test failures in t/ 
31lob_extended.t.  Any advice on what I need to do?

--Gisle


  perl -Mblib t/31lob_extended.t
1..31
ok 1 - created test table
ok 2 - created test data
DBD::Oracle::db do failed: ORA-01031: insufficient privileges (DBD  
ERROR: OCIStmtExecute) [for Statement "CREATE OR REPLACE PROCEDURE  
p_DBD_Oracle_drop_me(pc OUT SYS_REFCURSOR) AS
l_cursor SYS_REFCURSOR;
BEGIN
OPEN l_cursor FOR
   SELECT x from dbd_ora__drop_me;
pc := l_cursor;
END;
"] at t/31lob_extended.t line 164.
ok 3 - created test procedure
ok 4 - ora_auto_lobs prefetch prepare call proc
ok 5 - ora_auto_lobs prefetch - bind out cursor
DBD::Oracle::st execute failed: ORA-06550: line 1, column 7:
PLS-00201: identifier 'P_DBD_ORACLE_DROP_ME' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored (DBD ERROR: error possibly near <*>  
indicator at char 6 in 'begin <*>p_DBD_Oracle_drop_me(:p1); end;')  
[for Statement "begin p_DBD_Oracle_drop_me(?); end;" with  
ParamValues: :p1=DBI::st=HASH(0x844a530)] at t/31lob_extended.t line 57.
not ok 6 - ora_auto_lobs prefetch - execute to get out cursor
DBD::Oracle::st fetchrow failed: ERROR no statement executing  
(perhaps you need to call execute first) at t/31lob_extended.t line 61.
not ok 7 - ora_auto_lobs prefetch - lob locator retrieved
not ok 8 - ora_auto_lobs prefetch - is a lob locator
ok 9 # skip did not receive a lob locator
ok 10 # skip did not receive a lob locator
ok 11 # skip did not receive a lob locator
ok 12 # skip did not receive a lob locator
DBD::Oracle::st fetchrow failed: ERROR no statement executing  
(perhaps you need to call execute first) at t/31lob_extended.t line 63.
not ok 13 - ora_auto_lobs prefetch - lob locator retrieved
not ok 14 - ora_auto_lobs prefetch - is a lob locator
ok 15 # skip did not receive a lob locator
ok 16 # skip did not receive a lob locator
ok 17 # skip did not receive a lob locator
ok 18 # skip did not receive a lob locator
ok 19 - ora_auto_lobs prefetch - finished returned sth
ok 20 - ora_auto_lobs prefetch - finished sth
ok 21 - ora_auto_lobs not fetching prepare call proc
ok 22 - ora_auto_lobs not fetching - bind out cursor
DBD::Oracle::st execute failed: ORA-06550: line 1, column 7:
PLS-00201: identifier 'P_DBD_ORACLE_DROP_ME' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored (DBD ERROR: error possibly near <*>  
indicator at char 6 in 'begin <*>p_DBD_Oracle_drop_me(:p1); end;')  
[for Statement "begin p_DBD_Oracle_drop_me(?); end;" with  
ParamValues: :p1=DBI::st=HASH(0x84ac108)] at t/31lob_extended.t line 89.
not ok 23 - ora_auto_lobs not fetching - execute to get out cursor
DBD::Oracle::st fetchrow failed: ERROR no statement executing  
(perhaps you need to call execute first) at t/31lob_extended.t line 91.
not ok 24 - ora_auto_lobs not fetching - fetch returns something
ok 25 - ora_auto_lobs not fetching - not a lob locator
not ok 26 - ora_auto_lobs not fetching, first lob matches
DBD::Oracle::st fetchrow failed: ERROR no statement executing  
(perhaps you need to call execute first) at t/31lob_extended.t line 96.
not ok 27 - ora_auto_lobs not fetching - fetch returns something
ok 28 - ora_auto_lobs not fetching - not a lob locator
not ok 29 - ora_auto_lobs not fetching, second lob matches
ok 30 - ora_auto_lobs not fetching - finished returned sth
ok 31 - ora_auto_lobs not fetching - finished sth