Use utl_file_dir, or write to 'directories'? It would be hard to
execute the export utility from the package.

For utl_file you have to set the utl_file_dir parameter which requires
a reboot -- here is how you can open, write to, and close a file using
utl_file. For Directory example I'll let someone else respond.

__________________________________

V_Start varchar2(30);
V_End varchar2(30);
filehandle utl_file.file_type;
v_text varchar2(1000);
v_filedir varchar2(30);
v_filename varchar2(80);

--
BEGIN
--

v_filename := 'myfile.log';
filehandle := utl_file.fopen(v_filedir,v_filename,'W');
utl_file.new_line(filehandle,1);

utl_file.put_line(filehandle, 'ID:'||'abc'||' removed!');
utl_file.new_line(filehandle,1);
utl_file.put_line(filehandle,'Start Time: '||v_start);
utl_file.put_line(filehandle,'End Time: '||v_end);
DBMS_OUTPUT.PUT_LINE('Start Time: '||V_Start);
DBMS_OUTPUT.PUT_LINE(' End Time: '||V_End);

utl_file.fclose(filehandle);

-----Original Message-----
From: Chris
[mailto:oracledba-ezmlmshield-x13818632.[Email address protected]
Sent: Thursday, June 02, 2005 8:21 AM
To: LazyDBA Discussion
Subject: Flat File

I'm looking for a snippet of code to export data from several tables
into
a fixed width flat file from a Package....



-----Original Message-----
From: Chris
[mailto:oracledba-ezmlmshield-x13818632.[Email address protected]
Sent: Thursday, June 02, 2005 8:21 AM
To: LazyDBA Discussion
Subject: Flat File

I'm looking for a snippet of code to export data from several tables
into
a fixed width flat file from a Package....


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page