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

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
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com