This discussion is archived
3 Replies Latest reply: Jun 23, 2010 8:42 AM by zooid RSS

Need an extra set of eyes with procedure compile issue

zooid Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points