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.

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Do you HAVE to use Oracle Forms?

David

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 19:11:03 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.