title: PLS-00201: identifier UTIL_FILE must be declared
body: <p>I'm trying to export data from a query into a csv file from Oracle Enterprise Express installed on a Windows Server 2008 machine.  </p>
  
  <p>I've found this solution: </p>
  
  <p><a href="http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:235814350980">http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:235814350980</a></p>
  
  <p>which basically writes a function and uses the UTIL_FILE object to create and write to a file and add delimiters. </p>
  
  <p>I receive the follow error when I try and create the function in Oracle SQL Developer: </p>
  
  <pre><code>PLS-00201: identifier UTIL_FILE must be declared. 
  </code></pre>
  
  <p>When I run the following command:</p>
  
  <pre><code>select owner, object_type from all_objects where object_name = 'UTL_FILE' 
  </code></pre>
  
  <p>The result is: </p>
  
  <pre><code>OWNER      Object Type
  ---------  -----------
  PUBLIC     SYNONYM
  </code></pre>
  
  <p>EDIT: </p>
  
  <p>Running: </p>
  
  <pre><code>GRANT EXECUTE ON UTL_FILE TO PUBLIC
  </code></pre>
  
  <p>Gives: </p>
  
  <pre><code>Error starting at line 2 in command:
  GRANT EXECUTE ON UTL_FILE TO PUBLIC
  Error report:
  SQL Error: ORA-00942: table or view does not exist
  00942. 00000 -  "table or view does not exist"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>What is the problem?</p>