Pete Finnigan's Oracle Security Forum


    
      
        Pete Finnigan's Oracle Security Forum
        (http://www.petefinnigan.com/forum/yabb/YaBB.cgi)
      

        Oracle Security >> Oracle Security >> How to define utl_file for petefinnigan scripts?
        
(Message started by: Pete Finnigan on Mar 2^nd, 2010, 11:42am)

Title: How to define utl_file for petefinnigan scripts?
Post by Pete Finnigan on Mar 2^nd, 2010, 11:42am

On web page
http://www.petefinnigan.com/tools.htm
a couple of scripts were defined.
Unfortunately most of them require the definition
of an utl_file.

When I run them on my Oracle XE database I got errors similar to: see bottom

Which lines of code do I have to add resp. how should I define this utl_file to get these scripts running (as an sqlplus script)?

thx Peter

lg_fptr utl_file.file_type;
*
ERROR at line 8:
ORA-06550: line 8, column 11:
PLS-00201: identifier 'UTL_FILE' must be declared
ORA-06550: line 8, column 11:
PL/SQL: Item ignored
ORA-06550: line 133, column 3:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 133, column 3:
PL/SQL: Statement ignored

Title: Re: How to define utl_file for petefinnigan script
Post by Pete Finnigan on Mar 5^th, 2010, 10:08am

I spoke to Peter on email about this and the issue is not a bug in the scripts but the fact that he had revoked the public execute on UTL_FILE in his database - which is good!

If you get this issue make sure the user you are using has EXECUTE granted on UTL_FILE.

cheers

Pete