Home » SQL & PL/SQL » SQL & PL/SQL » Something about UTL_FILE package !!
Something about UTL_FILE package !! [message #221282] Mon, 26 February 2007 03:17 Go to next message
Splinter2010
Messages: 20
Registered: July 2006
Location: EGYPT
Junior Member

i tried hard to use the UTL_FILE package to write into I\O File the file i create it in this location.. C:/UTLFILE .. with name SAL_REP.text
...
then i write this line i the INIT.ORA .. utl_file_dir = c:/UTLFILE
the oraclegive me this error ..
" Correct the directory object parameter or create corresponding directory object with the CREATE DIRECTORY command"
i think that i miss understand something .. plz replay Thanks all for help
Re: Something about UTL_FILE package !! [message #221289 is a reply to message #221282] Mon, 26 February 2007 03:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
For all versions 9i and above you are supposed to use CREATE DIRECTORY command instead of UTL_FILE.
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/u_file.htm#998101
Re: Something about UTL_FILE package !! [message #221323 is a reply to message #221282] Mon, 26 February 2007 05:13 Go to previous messageGo to next message
Splinter2010
Messages: 20
Registered: July 2006
Location: EGYPT
Junior Member

thanks a lot .. but i need how i use the CREATE DIRECTORY command coz the web page you sent didn't describe the command with good way .. if you have example .. that will be so nice to you ..
thanks
Re: Something about UTL_FILE package !! [message #221326 is a reply to message #221323] Mon, 26 February 2007 05:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>didn't describe the command with good way .. i
Very unfortunate of it. It is the official documentation and is best available resource.
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/u_file.htm#998235
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/u_file2.htm#1000703

For more examples, search this forum
or just google.
http://www.psoug.org/reference/utl_file.html

[Updated on: Mon, 26 February 2007 05:38]

Report message to a moderator

Re: Something about UTL_FILE package !! [message #221455 is a reply to message #221326] Mon, 26 February 2007 21:37 Go to previous message
frenchm
Messages: 4
Registered: February 2007
Junior Member
You can use DIRECTORY objects, but you don't have to ...

Surely not as simple as the slash being the wrong way around in your UTL_FILE_DIR parameter?

ie. should be c:\UTLFILE
Previous Topic: Query rewrite failing to use an obvious MView candidate
Next Topic: Difference between Aggregate & Materialized View
Goto Forum:
  


Current Time: Sun Dec 04 00:23:15 CST 2016

Total time taken to generate the page: 0.09524 seconds