Home » SQL & PL/SQL » SQL & PL/SQL » How to setup INIT.ORA parameters (utl_file_dir)
How to setup INIT.ORA parameters (utl_file_dir) [message #232116] Thu, 19 April 2007 09:01 Go to next message
Messages: 21
Registered: March 2007
Location: Chennai
Junior Member
Dear Sir's,

Please guide me regarding setup of INIT.ORA parameters (utl_file_dir)

Chandrasekhar B.S.
Re: How to setup INIT.ORA parameters (utl_file_dir) [message #232122 is a reply to message #232116] Thu, 19 April 2007 09:39 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you are on Oracle 8 or 8i, set the UTL_FILE_DIR parameter to the path, or list of paths on the server that you wish UTL_FILE to be able to access.
If you are using Oracle 9 or higher, use the CREATE DIRECTORY as an alternative (and superior) way to specify directories.
Previous Topic: How to generate Excel File through Pl/sql Procedure
Next Topic: Total sum with Count in same query
Goto Forum:

Current Time: Fri Jul 21 00:02:34 CDT 2017

Total time taken to generate the page: 0.11376 seconds