>----- Original Message -----
>From: Rahul <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Sun, 26 May 2002 22:18:18
>
>list, the requirement is to use the UTL_FILE
>package on the server side to
>open and process the files as they are created
>(each hour) in a server's
>directory !!
>could anyone suggest a logic to pick up the the
>lastest file created in that
>dir. ?
>
>TIA
>
>8.1.6 on win2k
>
The best solution I can think of is to make the filename predictable - if it contains
some time of timestamp (eg YYMMDDHH24) the Oracle side can deduce in advance from
SYSDATE which file it must open. Short of that, you can have a 'utility' file in which
some procedure keeps track of the latest file - Read it first, then open the actual
data file.
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroul
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
