Hi all,
i create my first procedure to dump a table in a text file with package UTL_FILE but this error is raised :
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYS.UTL_FILE" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "MYUSER.myProcedureName", line 7
ORA-06512: at line 1
I woukd like to write the file into a directory already existing with read and write permissions for
MYUSER and i also execute the CREATE DIRECTORY for the path on the server.
What i miss? Any suggestion will be appreciated.
Regards.
Alex