UTL package [message #256755] |
Mon, 06 August 2007 09:19  |
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
|
|
|
|
|
|