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
