Make sure that the parameter UTL_FILE_DIR in your init.ora points to the
directory where you want to create the output file. And your oracle user
must have write permission in this dir.
makar wrote:
>
> I want to use UTL file package. I have created a sample procedure to test.
[SNIP]
*
> 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 "ESWAR.UTL_TEST", line 8
> ORA-06512: at line 1
Received on Thu Oct 01 1998 - 01:33:26 CDT
