RE:UTL_FILE must be declared
Hello all!
I've just been given a PC which has Oracle10XE on it however the person who installed it has left so i don't know the SYS password.
I'm trying to use UTL_FILE but i get
PLS-00201: identifier 'UTL_FILE' must be declared
I try to correct using
grant execute on UTL_FILE to public;
but i get
ORA-00942: table or view does not exist
I'm solutions looking @ on the Net seem to require me to log in as SYS but i can't seem to since i don't know SYS password.
I'm also trying to create a new password file in hope of giving SYS another password but get
OPW-00001: Unable to open password-file
Can anyone plz help me so that in the end, i'm able to use UTL_FILE
Thnx so much