error in code UTL_FILE

[prasad joshi]

hello

I have got this error.
ORA-06550: line 2, column 5:
PLS-00201: identifier 'UTL_FILE' must be declared
ORA-06550: line 2, column 5:
PL/SQL: Item ignored
ORA-06550: line 5, column 4:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 5, column 4:
PL/SQL: Statement ignored
ORA-06550: line 6, column 22:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 6, column 4:
PL/SQL: Statement ignored
ORA-06550: line 7, column 20:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 7, column 4:
PL/SQL: Statement ignored
..................................................


I am writting this code

Please tell me what mistake I have made

 
DECLARE
  f UTL_FILE.FILE_TYPE;
  s VARCHAR2(200);
BEGIN
   f := UTL_FILE.FOPEN('c:\Documents and Settings\joshipr\Desktop\New Folder','data.txt','R');
   UTL_FILE.GET_LINE(f,s);
   UTL_FILE.FCLOSE(f);
   DBMS_OUTPUT.PUT_LINE(s);
END;
 

Please help me urgent guys.

[helparod]

Hi,
First try checking if you user which you're executing the query has permission to execute utl_file:

select *
from dba_tab_privs
where table_name like 'UTL_FILE';

if your user doesnt appear, you have to grant permission in this way:

grant execute on sys.utl_file to <user/public>;

Let me know if it works for you.

Helen.