Home » SQL & PL/SQL » SQL & PL/SQL » utl_file.fopen (Oracle 10g R-2)
utl_file.fopen [message #277635] Wed, 31 October 2007 00:07 Go to next message
nirajksharmacpr
Messages: 19
Registered: October 2007
Location: Mumbai
Junior Member

hi All
I have useing the UTL_FILE package.
f := utl_file.fopen('DIR_TEMP', 'something.txt', 'w');
DIR_TEMP has Directory 'c:\Temp' in Create Directory Command
Its Working Properly. My Query is 'something.txt' file Created in Which Location. in which Directory .

Please Suggest Me.

Thanks And Regards.
Re: utl_file.fopen [message #277656 is a reply to message #277635] Wed, 31 October 2007 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It is created in directory pointed by DIR_TEMP.

Regards
Michel
Re: utl_file.fopen [message #277658 is a reply to message #277635] Wed, 31 October 2007 01:46 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

desc dba_directories;
Re: utl_file.fopen [message #277699 is a reply to message #277635] Wed, 31 October 2007 04:18 Go to previous messageGo to next message
nirajksharmacpr
Messages: 19
Registered: October 2007
Location: Mumbai
Junior Member

Thanx for this
But i want to Open the File Manually b'coz file is not Stored in my Path. Where it is save and Created.

Thnx
Re: utl_file.fopen [message #277700 is a reply to message #277699] Wed, 31 October 2007 04:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Question
What is the question?

Regards
Michel
Re: utl_file.fopen [message #277703 is a reply to message #277699] Wed, 31 October 2007 04:30 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
As has already been explained - it is created in the directory refered to by the row in DBA_DIRECTORIES for the directory DIR_TEMP
Previous Topic: How to update a table based on other table field value?
Next Topic: Looping through all records of an unknown table
Goto Forum:
  


Current Time: Fri Feb 07 09:31:09 CST 2025