Looks like you're running this as the Oracle user 'JAY', maybe it should
be run as SYS or internal instead.
Luck.
- sooz
jshobe_at_my-dejanews.com wrote:
>
> 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
>
> J.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat May 01 1999 - 15:02:08 CDT
