how to create a txt file from PL/SQL procedure

[bsathishmca]

Hi,

I have a procedure that contains a varchar2 variable,now i need to create a text file in from procedure and move varchar2 content into the file.

Can any one help?

Thanks in advance

[amitpatel66]

Check UTL_FILE PACKAGE

[bsathishmca]

Check UTL_FILE PACKAGE

Hi,

I am using oracle client.I need to create text file in my system using Utl_File.File_T ype.how to give dir path?

[amitpatel66]

Check here
.