OraFAQ Forum: Forms » Data loading from text file (merged 2 by MC)

Home » Developer & Programmer » Forms » Data loading from text file (merged 2 by MC) (Forms, 11g, windows)

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

Data loading from text file (merged 2 by MC) [message #658828]

Wed, 28 December 2016 03:04

AyeshaSaad
Messages: 16
Registered: December 2016

Junior Member

Dear All
I have developed my application in Forms11g and configured weblogic server, my remote users are using application successfully.
Now my problem is, in our company sales team send us their orders through text files which I want to load into my system and generate invoices against these orders.
In our Forms6i application we are using SQLLDR but I don't know how to use SQLLDR in forms11g?

Please guide me.

Thanks in advance.

Report message to a moderator

Data loading from text file [message #658830 is a reply to message #658828]

Wed, 28 December 2016 03:35

AyeshaSaad
Messages: 16
Registered: December 2016

Junior Member

Dear All
I have created my application in Forms11g and configured weblogic server now my remote users (outside/inside city) are using application.
My problem, our sales team send text files through email which we have to load in our system and generate invoices against these orders.

In our Forms6i application we were using SQLLDR but how to load text files data on daily basis in Forms11g?

Please advise.

Thanks in advance

Report message to a moderator

Re: Data loading from text file [message #658843 is a reply to message #658830]

Wed, 28 December 2016 07:45

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why do you repost the same question?
The only result will be you'll make people angry and get no answer.
Wait, this is a cooperative forum, you pay nothing, no one owe you an answer; in addition, maybe the one who knows the answer is 12 hours or more away from you and will read your question when you'll be asleep.

Report message to a moderator

Re: Data loading from text file [message #658865 is a reply to message #658843]

Wed, 28 December 2016 22:24

AyeshaSaad
Messages: 16
Registered: December 2016

Junior Member

Sorry for the dual posting, I wanted to delete my first post but unable to find post delete option.

Report message to a moderator

Re: Data loading from text file [message #658867 is a reply to message #658865]

Thu, 29 December 2016 00:12

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

Senior Member
Account Moderator

How did you run SQL*Loader in your Forms 6i application? Was it by the HOST built-in which called a .BAT script which ran SQLLDR? If so, it still exists (at least, I believe so, I don't have Forms 11g to check) but operates on the server machine. Therefore, create a (shared) folder on the application server so that users could put text files in there. Modify the .BAT script so that it sees those files. Call it from a form, as usual.

Report message to a moderator

Re: Data loading from text file [message #658871 is a reply to message #658867]

Thu, 29 December 2016 02:45

AyeshaSaad
Messages: 16
Registered: December 2016

Junior Member

Thanks Littlefoot, I will try and then update you.

Report message to a moderator

Previous Topic:	help menu
Next Topic:	Forms 6.0 Runtime Failure & Forms 6.0 runtime error-please help me (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 14:32:32 CDT 2025