Home » Developer & Programmer » Forms » Form 6i: Read text file va (Form 6i, WinXP)
Form 6i: Read text file va [message #413227] Tue, 14 July 2009 20:35 Go to next message
achilles78
Messages: 5
Registered: January 2008
Junior Member
hi all!

I am using oracle 61 Form Developer. i want to read text file (this text file have structure: see attatch file) from local computer drive and insert rows to the Oracle 9i Database. Please help me.
thanks in advance
Re: Form 6i: Read text file va [message #413237 is a reply to message #413227] Tue, 14 July 2009 23:13 Go to previous message
shaz
Messages: 182
Registered: June 2009
Senior Member
just use the client_text_io package in webutil library. By using this you can open, close, read, write, etc a file. In this u will get a inbuilt function get_line which will read the text line by line.
Apply your logic and separate all the three fields and simply insert them to the database.

for reference just read the the help of the forms.

hope this helps!
Previous Topic: frm-10044 :cannot create file
Next Topic: A beginner with Oracle forms
Goto Forum:
  


Current Time: Fri Sep 20 10:34:22 CDT 2024