My suggestion would be to use SQL*Loader to load the data into a
temporary table and then use a stored procedure to manipulate the
data into your final table structure.
At least under 8* If you want to use UTL_FILE you will need to tell
Oracle that it has permission to read and write files in the directory
that the csv file is keep. i.e in your intSID.ora set the following
# Where Oracle can read and write.
UTL_FILE_DIR=/tmp
Regards Kevin B.
PRIVILEGED, PRIVATE AND CONFIDENTIAL
=======================================================
The information contained in this electronic message e-mail, and
any files transmitted with it, is intended for the named recipient(s)
only. If you are not the intended recipient, you must not copy,
distribute or take any action in reliance on it, please delete it
immediately and notify me of the error by reply e-mail. I do not
represent, warrant or guarantee that the integrity of this
communication has been maintained nor that the communication
is free of errors, virus or interference.
=======================================================
Kevin Biasi
Software Engineer
Dimension Data
Telephone - 61 3 9626-0379
E-ddress - kevin.[Email address protected]
"Hugo Bouckaert "
<oracledba-ezmlmshield-x42003150.[Email address protected]
12/11/2004 05:55 PM
To: "LazyDBA Discussion" <[Email address protected]
cc:
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