Home » Developer & Programmer » Forms » How to insert text file(.txt) to oracle database using oracle form 10g?
How to insert text file(.txt) to oracle database using oracle form 10g? [message #253137] Sun, 22 July 2007 22:09 Go to next message
form10g
Messages: 2
Registered: July 2007
Location: Jakarta
Junior Member
I have a problem, can anybody help me?
I have text file (.txt), i want to insert data from that text file to oracle database using oracle form10g, can you help me how to do that using form10g ??

thanks for your help.
Re: How to insert text file(.txt) to oracle database using oracle form 10g? [message #253192 is a reply to message #253137] Mon, 23 July 2007 01:45 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you HAVE to use Oracle Forms?

David
Re: How to insert text file(.txt) to oracle database using oracle form 10g? [message #253209 is a reply to message #253192] Mon, 23 July 2007 02:36 Go to previous messageGo to next message
form10g
Messages: 2
Registered: July 2007
Location: Jakarta
Junior Member
yes, i have to use oracle form.
Re: How to insert text file(.txt) to oracle database using oracle form 10g? [message #253857 is a reply to message #253137] Wed, 25 July 2007 02:19 Go to previous messageGo to next message
oralover
Messages: 97
Registered: January 2005
Member
TEXT_IO package can help you.
Re: How to insert text file(.txt) to oracle database using oracle form 10g? [message #254636 is a reply to message #253857] Fri, 27 July 2007 05:50 Go to previous message
linlasj
Messages: 98
Registered: August 2005
Location: Linköping
Member
Hi,
Yes, as oralover says, TEXT_IO is the way to go.
Or treat the file as a flat file from the DB directly and read it in that way.
Or you can use UTL_FILE to read it, I presume, or you
can use sql*Loader to load it.


Br
Lars
Previous Topic: Migration from 6i to 10g
Next Topic: how can save record from control block
Goto Forum:
  


Current Time: Thu Dec 08 20:00:04 CST 2016

Total time taken to generate the page: 0.05237 seconds