On Jul 29, 2008, at 00:18, 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().
That would be nice.
At least the README should then spell out what rights are needed by
the test user. Currently it says:
So you should set that to a valid user (e.g. 'scott/tiger') and
ensure that
this user has sufficient privileges to create, insert into, select
from and
drop a table, and is able to select from systemtables like 'v
$sessions'.
so it sounds like privileges to manipulate tables is all it takes. I
did not have test failures with 1.21, so this privilege is a new
requirement for the test user in 1.22.
Unfortunately for me I don't have the powers to grant anything to my
test user and the person that has the power is on vacation :(
--Gisle
