1  create or replace procedure test as
  2  test_file utl_file.file_type;
  3  begin
  4  test_file:=utl_file.fopen('/tmp/', 'test.txt', 'w') ;
  5  utl_file.fclose(test_file);
  6* end ;
SQL> /

Procedure created.

SQL> exec test
BEGIN test; END;

*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "USER1.UTL_FILE" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "USER1.TEST", line 4
ORA-06512: at line 1


SQL> exec test
BEGIN test; END;

*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "USER1.UTL_FILE" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "USER1.TEST", line 4
ORA-06512: at line 1