Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
PL/SQL UTL_FILE create text file problem
Thank you for this information I did not see this in my Pl/sql book. I was wondering if there is a command I could use to write a test file to my pc. I will be running this program once a week so it would be nice to have it write to my pc.- tmorf
- Post #5
- Forum: Oracle: All versions
-
PL/SQL UTL_FILE create text file problem
Not sure what the init.ora file is or where to find it. I'm just trying to do a select from a database table and create a text file on my pc. I thought defining them in the program would be all I needed. p_file_name := 'outputfile.txt'; p_file_dir := 'c:'; v_file_handle :=...- tmorf
- Post #3
- Forum: Oracle: All versions
-
PL/SQL UTL_FILE create text file problem
I am trying to create a flat file. I included my pl/sql code below also I'm just a starting to learn pl/sql. I found some examples on this web site and in a oracle pl/sql book but can't fix my problem. The program runs with no errors but does not produce a flat file on my c drive. Any help...- tmorf
- Thread
- Replies: 5
- Forum: Oracle: All versions
