packages - permissions?

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. Received on Sun Nov 04 2007 - 09:02:50 CST