Hi, I have installed in Oracle 11g XE and the need to declare UTL_FILE.
When you run a package you get the error: PLS-00201: identifier 'UTL_FILE' must be Declared.
At various forums refer both to create a user SYS, and I use the command:
Grant execute on UTL_FILE to sys;
The problem is that there is not user SYS in Oracle 11g XE. There is only user SYSTEM.
When I log in as a system and applies GRANT command .... and I get the error:
ORA-00942: table or view does not exist
How can I UTL_FILE grant and declare to Oracle 11g XE?
I'm sorry, my English is not the best.