Home » SQL & PL/SQL » SQL & PL/SQL » UTL package
UTL package [message #256755] Mon, 06 August 2007 09:19 Go to next message
palmer18
Messages: 6
Registered: June 2007
Junior Member
Hi,
I need to spool output of my procedure to a text file.
I'm using utl file package:

my_file := UTL_FILE.FOPEN('E:\oracle', 'myfile.txt', 'w');
.
.

the path to a file must be specified in INIT.ora, but I am not DBA and have no chance to modify this init.ora

Is it possible to use this package in combination with oracle diretories (CREATE DIRECTORY ...) and let my procedure to create output files in this direcory ? thanks
Re: UTL package [message #256757 is a reply to message #256755] Mon, 06 August 2007 09:21 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
What version is your database ?
Re: UTL package [message #256762 is a reply to message #256757] Mon, 06 August 2007 09:41 Go to previous messageGo to next message
palmer18
Messages: 6
Registered: June 2007
Junior Member
it is oracle 10.2.0.3.0
Re: UTL package [message #256785 is a reply to message #256762] Mon, 06 August 2007 11:51 Go to previous message
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
Senior Member
In that case, directory objects are recommended and UTL_FILE_DIR is deprecated.

http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_file.htm
Previous Topic: multiple optimizer hints
Next Topic: MAIL
Goto Forum:
  


Current Time: Tue Feb 18 10:42:47 CST 2025