RE: UTL_FILE question

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sat, 31 Jan 2004 00:59:27 -0800
Message-ID: <F001.005DE78E.20040131005927@fatcity.com>

Message

I would create a new version of the procedure that took the date from and to as parameters and output a file named appropriately for the date range. You would then just call this 24 times.

Niall

-----Original Message-----
From: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On Behalf Of Viktor
Sent: 31 January 2004 00:24
To: Multiple recipients of list ORACLE-L
Subject: UTL_FILE question

Hello,

I have a procedure that open a cursor and dumps some data for last 24 months to a file. The date range is static condition defined inside the cursor. Procedure is working great, but I what I'm having problem figuring out is if there is a way to create not one file with all the data, but multiple files with monthly sets of data. This way data for month1 is created as <filename_012002.txt> and so forth.

Thanks much!

Viktor

Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  INET: niall.litchfield_at_dial.pipex.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sat Jan 31 2004 - 02:59:27 CST