utl_file

From: <jshobe_at_my-dejanews.com>
Date: Fri, 30 Apr 1999 20:01:47 GMT
Message-ID: <7gd278$bv7$1@nnrp1.dejanews.com>

I am trying to use the utl_file package. I ran UTL_FILE.SQL in sql+. I have the following line in a stored procedure: iFile := utl_file.FOPEN ('c:\temp', 'rebuild.txt', 'a');

When I run it, I get the following error: ERROR at line 1:

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

Any ideas?

Thanks

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 30 1999 - 15:01:47 CDT