Re: DBD::Oracle - rt13865.t

On 13/12/12 16:38, Scott wrote:
>
> I have to comment out the 'DROP TABLE' check to get this test to run. In Oracle, AFAIK, there is not a
> DROP TABLE privilege.  If you can create it, you can drop it.   Does this test not run for everyone?
>
>
>   unless (    ( $priv{'CREATE TABLE'} or $priv{'CREATE ANY TABLE'} )
> ){
> #        and ( $priv{'DROP TABLE'} or $priv{'DROP ANY TABLE'} ) ) {
>      plan skip_all => q{requires permissions 'CREATE TABLE' and 'DROP TABLE'};
> }
>
>
> Scott

Works and runs for me:

$ prove -vb t/rt13865.t
t/rt13865.t ..
1..9
ok 1 - INTEGER is alias for NUMBER(38)
ok 2 - NUMBER(37)
ok 3 - NUMBER
ok 4 - VARCHAR(67)
ok 5 - VARCHAR(69)
ok 6 - NVARCHAR2(69)
ok 7 - NCHAR(69)
ok 8 - CHAR(67)
ok 9 - CHAR(69)
ok
All tests successful.
Files=1, Tests=9, 12 wallclock secs ( 0.03 usr  0.01 sys +  0.14 cusr  0.07 csys =  0.25 CPU)
Result: PASS


-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com