| UTL_FILE??? [message #97565] |
Sun, 04 August 2002 19:22  |
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  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
