Is there a reason that you don't want to use SQL*Loader and/or external
tables for this? That would load the data faster and would be easier to
code.

Justin Cave <[Email address protected]
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Hugo Bouckaert
[mailto:oracledba-ezmlmshield-x42003150.[Email address protected]
Sent: Friday, November 12, 2004 1:55 AM
To: LazyDBA Discussion
Subject: UTL_FILE procedure example import from delimted text file to
table

Hi

I am struggling a bit trying to write a procedure that uses UTL_FILE to
import comma-delimited data from a text file into a table. Would anyone
have a simple example I can have a look at to tailor my plsql code on?
That would be much appreciated.

Thanks

Hugo


Dr Hugo Bouckaert
Systems and Programming Engineer

Geoinformatics Exploration Australia P/L
57 Havelock St
West Perth, WA 6005
PO Box 1675, West Perth 6872

Ph: 61 08 9420 7400
Fax: 61 08 9226 1299

www.geoinformex.com

------------------------------------------------------------------------

This email and any attachments may be confidential or legally
privileged. If you received this message in error or are not the
intended recipient, you should destroy the e-mail message and any
attachments or copies, and you are prohibited from retaining,
distributing, disclosing or using any information contained herein.
Please inform us of the erroneous delivery by return e-mail. Thank you
for your cooperation.




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page