Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> UTL_FILE problems
I am having trouble getting the UTL_FILE procedures working. I ran the UTLFILE.sql script but I keep getting the following error ...
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "SYS.UTL_FILE", line 82 ORA-06512: at "SYS.UTL_FILE", line 120 ORA-06512: at "TEST.SECURE", line 15 ORA-06512: at line 1 This is after I try to open a file. It runs fine when I simplycreate a UTL_FILE variable.
I inserted a UTL_DIRECTORY line into the init.ora file and restarted the db. Can you only put unix directories on this path?
-- kshave_at_minet.gov.mb.caReceived on Mon Mar 10 1997 - 00:00:00 CST