Jake wrote:
> I am trying to use UTL_FILE in a procedure like:
>
> UTL_FILE.FOPEN(v_directory, v_file_name, 'A');
>
> when I log in as SYSDBA it compiles, when I log in otherwise I get:
>
> PLS-00201: identifier 'UTL_FILE' must be declared
>
>
> Is this a permissions problem? What should I do so that I may compile
> this code without logging in as SYSDBA?
>
> thanks.
GRANT execute ON utl_file TO <schema_name>;
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Nov 04 2007 - 13:43:03 CST
