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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Viktor
Sent: 31 January 2004 00:24
To: Multiple recipients of list ORACLE-L
Subject: UTL_FILE questionHello,
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!