Form 6i: Read text file va [message #413227] |
Tue, 14 July 2009 20:35 |
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 |
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!
|
|
|