Import/Export flat file data into forms
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 4111Received on Fri Sep 15 1995 - 00:00:00 CEST