Martin Evans wrote:
Tim Bunce wrote:
On Mon, Jul 28, 2008 at 05:35:14PM -0400, John Scoles wrote:
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
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.
Sure, but tests shouldn't fail just because of a lack of privs.
The test needs to detect that and do a skip().
Tim.
That is my fault - I wrote that test and I didn't think about
privileges. I would attach a patch but it will probably be deleted from
this list so I've sent it to John and if anyone else specifically wants
it let me know.
BTW, there are a lot of other tests will fail for users with few
privileges - the worst being unable to create a table but there are
others like selects from v$session. I have not patched all those as well.
Martin
For anyone interested the tests which fail for limited privileges (i.e.,
create table privilege, connect, unlimited table space) are:
28array_bind
attempts to create a sequence - not handled
t/31lob
attempt to select from v$session - I think this one is handled
t/50cursor
Can't determine open_cursors from v$parameter - handled
t/56embbeded
tries to create a type - not handled
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
