Home » Infrastructure » Unix » UTL_FILE???
UTL_FILE??? [message #97565] Sun, 04 August 2002 19:22 Go to next message
cloud
Messages: 2
Registered: August 2002
Junior Member
Hi,
I have this problem in reading xml file and inserting data into the oracle tables.

ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 98
ORA-06512: at "SYS.UTL_FILE", line 157
ORA-06512: at line 10
Could u please tell me the solution
Re: UTL_FILE??? [message #97567 is a reply to message #97565] Mon, 05 August 2002 02:31 Go to previous messageGo to next message
Manolo
Messages: 3
Registered: August 2002
Junior Member
Hello Cloud:
I think there's a problem with the definition of the file you are writing to.

Check that the file exists and, in case you are trying to write to the file, check that the file is in a directory defined in INIT.ORA for the package UTL_FILE.

Every directory being written through UTL_FILE has to be defined in INIT.ORA:
UTL_FILE_DIR=#Directory#

Hope this will be useful.
Thanks!! [message #97568 is a reply to message #97567] Mon, 05 August 2002 18:05 Go to previous message
cloud
Messages: 2
Registered: August 2002
Junior Member
Thanks a lot!
Previous Topic: Oracle on Unix
Next Topic: Re: ORA-01012
Goto Forum:
  


Current Time: Tue Sep 29 06:21:07 CDT 2020