OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Loading data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Loading data [message #321457]

Tue, 20 May 2008 05:46

hany_marawan
Messages: 198
Registered: April 2005
Location: Cairo - Egypt

Senior Member

Hello,
I have data in text file and I want to load it to my schema to use it my program which is working as a responsibility in the e_business.
I want to build a form to load this data in the database.
How can I do this.
Please I want an example

Thanks

Report message to a moderator

Re: Loading data [message #321522 is a reply to message #321457]

Tue, 20 May 2008 10:24

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

use Data loader, for example from http://www.simonhuggins.com/arctan/dataloader/

Report message to a moderator

Re: Loading data [message #321705 is a reply to message #321457]

Wed, 21 May 2008 01:59

hany_marawan
Messages: 198
Registered: April 2005
Location: Cairo - Egypt

Senior Member

Thanks,
But I know the dataloader, but I want it by programming.
Thanks

Report message to a moderator

Re: Loading data [message #322032 is a reply to message #321457]

Thu, 22 May 2008 04:19

lazycat
Messages: 57
Registered: November 2005

Member

sqlloader can help you

thank

Report message to a moderator

Re: Loading data [message #322351 is a reply to message #321457]

Fri, 23 May 2008 03:40

raju_kamarapu
Messages: 19
Registered: February 2008
Location: KAULAMPUR

Junior Member

Use external table concept, u can create external table in procedure and can give the path there.

Report message to a moderator

Re: Loading data [message #322377 is a reply to message #322351]

Fri, 23 May 2008 05:17

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Of course, one should pay attention to the fact that external tables weren't available in versions prior to 10g.

Report message to a moderator

Previous Topic:	Concurrent Program using SQL * Loader
Next Topic:	Adding Supplier organization type

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 13:14:08 CDT 2024