Writing data to file using UTL_FILE package

[amitpatel66]

You can search in this forum by typing in the keyword utl_file in the SEARCH box at the top right corner of the forum windowto get some sample codes.

But you run the code that I have provided you in my previous post to check what could be the exact error and post back the error for reference.

[change]

HI RAN THE CODE AND THIS IS THE ERROR;;;


1,User-Defined Exception

[change]

HI WAS DOING SOME REDING AND CAME ACROOS::::

Here's the format of the parameter for file access in the INIT.ORA file:

utl_file_dir = <directory>


PROBLEM IS WHERE DO I DECLARE THIS IN MY CODE

[change]

where to DECLARE UTL_FILE_DIR

scribes

am trying to use utl_file and need to declare the directory in init.ora and i went to the oracle registry folder and i cant seem to find it....help please

[amitpatel66]

HI WAS DOING SOME REDING AND CAME ACROOS::::

Here's the format of the parameter for file access in the INIT.ORA file:

utl_file_dir = <directory>


PROBLEM IS WHERE DO I DECLARE THIS IN MY CODE

If you want to change the value of utl_file_dir, then you need to change that init.ora file and bounce the database server to take in to effect the modified value

[amitpatel66]

scribes

am trying to use utl_file and need to declare the directory in init.ora and i went to the oracle registry folder and i cant seem to find it....help please

You need to assign the directory value to utl_file_dir parameter in init.ora file. The init .ora file is present in ORACLE_HOME/dbs path. Check for INIT.ORA File, assign the directory value to the utl_file_dir parameter and bounce the DB server. You can ask your DBA to do this for you.

[amitpatel66]

Duplicate Threads merged for better management of forum


MODERATOR