Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> UTL_FILE problems

UTL_FILE problems

From: Keith S. <kshave_at_MBnet.MB.CA>
Date: 1997/03/10
Message-ID: <kshave.858006666@access>#1/1

        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 simply
create 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.ca
Received on Mon Mar 10 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US