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

Gisle Aas wrote:
> 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


Ok that is an easy one. This is not a DBD::Oracle or DBI error it simply 
means the user you are running the test as does not have the privileges 
to create an stored procedure.  Grand your user some more rights and the 
test should pass.

Cheers
John Scoles
> 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