Re: utl_file

Either you don't have execute privilege on the package, or the public synonym utl_file doesn't exist. Administrative script usually should be run in svrmgr, connected as internal

Hth,

Sybrand Bakker, Oracle DBA

jshobe_at_my-dejanews.com wrote in message <7gd278$bv7$1_at_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
>
>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 - 16:16:21 CDT