Import/Export flat file data into forms

From: Terence Chew <terence_at_cit.gu.edu.au>
Date: 1995/09/15
Message-ID: <43beh9$ru5_at_enterprise.sct.gu.edu.au>#1/1


I need to be able to import a flat file that is on a PC or Mac into an Oracle database running on a Sun box. The PC or Mac is running Forms 4.0 and SQL*Net. Whatever the solution, it has to be able to be done on Macs and PCs.

Is there any way to read in a file from Forms 4.0 on the client side for the purposes of inserting/updating the database? If not, is there an SQL*Loader utility on the PC and the Mac that can be activated from within Forms 4.0? I understand there is one for the PC that comes with Personal Oracle7. I haven't tried it because I can't find one for the Mac.

The problem is essentially the automation of loading a flat file into an Oracle table.

If anyone has had any success with the same problem, please tell me how you did it.

Thanks in advance,

-- 
Terence Chew       	Computing Support Section
T.Chew_at_cit.gu.edu.au	Faculty of Computing and Information Technology
Ph:   +61 7 3875 5421	Griffith University 
Fax:  +61 7 3875 5425	Nathan, Brisbane, Queensland, Australia 4111
Received on Fri Sep 15 1995 - 00:00:00 CEST

Original text of this message