3 Replies Latest reply: Jun 23, 2010 10:42 AM by zooid RSS

    Need an extra set of eyes with procedure compile issue

    zooid
      Hi everyone,

      I am trying to write a procedure for

      Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
      PL/SQL Release 10.2.0.1.0 - Production
      CORE 10.2.0.1.0 Production
      TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
      NLSRTL Version 10.2.0.1.0 - Production

      and I get the following compiler error:

      PLS-00201: identifier 'UTL_FILE' must be declared

      the sample procedure is :

      CREATE OR REPLACE PROCEDURE TEST_A IS

      fhandle UTL_FILE.FILE_TYPE;


      tmp NUMBER;

      BEGIN

      tmp := 1;

      END;

      Edited by: zooid on 23-Jun-2010 08:18