RE: how to pick the lastes file using UTL_FILE package ?

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Mon, 27 May 2002 00:48:23 -0800
Message-ID: <F001.0046C037.20020527004823@fatcity.com>

('binary' encoding is not supported, stored as-is)

>----- Original Message -----
>From: Rahul <rahul_at_ratelindo.co.id>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>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: sfaroult_at_oriolecorp.com

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: 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 Mon May 27 2002 - 03:48:23 CDT