RE: utl_file and record delimters

From: Thomas, Kevin <Kevin.Thomas_at_calanais.com>
Date: Wed, 24 Oct 2001 07:20:02 -0700
Message-ID: <F001.003B31E6.20011024073522@fatcity.com>

Does utl_file not just read the file a line at a time and then it is upto you to programmatically divide the data up into it's chunks using substr etc.

Kev.
"hit any user to continue"

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com

-----Original Message-----
Sent: 24 October 2001 15:30
To: Multiple recipients of list ORACLE-L

I need to use utl_file on a Unix server to process DOS format(CRLF) files. can I sepcify to utl_file waht the record delimiter is...or do I need to convert the files to Unix format before utl_file will read them correctly?

John

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: John Dunn
INET: john.dunn_at_sefas.co.uk

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Thomas, Kevin
INET: Kevin.Thomas_at_calanais.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------