Re: loading LOTS of ascii files into varchar2

From: AlexJent <alexjent_at_aol.com>
Date: 1997/03/08
Message-ID: <19970308202101.PAA01715@ladder01.news.aol.com>#1/1

Garry,
You didn't specify tour platform or Oracle version....But,

If you are at pl/sql 2.2 or higher you can use the UTL_FILE package to open the files read them into pl/sql variables(up to 32767 long) and easly do what you need.

Good luck.

Alex Jentilucci - Consultant
Information System Dynamics, Inc
Minneapolis, MN 55323
Tele: 612-476-7395 FAX: 612-473-5954 E-Mail: infosys_at_aol.com

E-Mail Work: jentilucci_at_notes.seagate.com

Home: AlexJent_at_aol.com Received on Sat Mar 08 1997 - 00:00:00 CST