OraFAQ Forum: Forms » Upload Data from flat File

Home » Developer & Programmer » Forms » Upload Data from flat File

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

Upload Data from flat File [message #377035]

Fri, 19 December 2008 09:33

ramtin
Messages: 37
Registered: November 2008

Member

Hi

I need to create a new oracle Form which upload flat file from client PC to database and also create a log file for this upload. Did you have any experience about this? Please advice.

Thank you so much in advance.

Report message to a moderator

Re: Upload Data from flat File [message #377056 is a reply to message #377035]

Fri, 19 December 2008 12:00

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

Senior Member
Account Moderator

SQL*Loader is the tool do load data from a flat file into Oracle. It will also create a log file.

Invoke it (from the form) using HOST or CLIENT_HOST built-ins.

Report message to a moderator

Re: Upload Data from flat File [message #377076 is a reply to message #377035]

Fri, 19 December 2008 21:37

shahnirav86
Messages: 13
Registered: June 2008
Location: anand,gujarat

Junior Member

hi,
please which database u used..you have to write script using ftp
if you are using unix database sever...
which application server used?
here solution:
first you have to upload file on application sever.
then database server and then you used sql * loader to upload data from file

Report message to a moderator

Re: Upload Data from flat File [message #377093 is a reply to message #377076]

Sat, 20 December 2008 02:03

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

Senior Member
Account Moderator

Huh?

shahnirav86

first you have to upload file on application sever.
then database server and then you used sql * loader to upload data from file

I'm not sure I understood that. Are you saying that you first upload file to an application server, then you upload the same file to a database server, and then you use SQL*Loader and load data stored in that file into an Oracle database?

If so, well, why do you do that in such a complicated manner? SQL*Loader is available locally (can be installed as a part of Oracle Client software); you don't have to move file anywhere - it can be stored on your PC.

So - if you know how to write a control file, there's nothing much you have to do regarding input file manipulation - no servers must be included into the business (unless, of course, the fact that Oracle must be up in order to successfully load data).

Report message to a moderator

Re: Upload Data from flat File [message #377349 is a reply to message #377093]

Mon, 22 December 2008 08:20

ramtin
Messages: 37
Registered: November 2008

Member

Hi All,

Thank you for all information. However the client likes to upload the Data file from their own PC and I have to create an oracle Form which does that for them. I thought I can use PL/SQL in Oracle Form for this job. Please advice.

Thanks and Happy holiday

Report message to a moderator

Re: Upload Data from flat File [message #377374 is a reply to message #377349]

Mon, 22 December 2008 10:18

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

Senior Member
Account Moderator

Re-read my first answer to your question - call SQL*Loader from a form using the HOST or CLIENT_HOST built in.

Or, you might research use of the TEXT_IO.

Report message to a moderator

Re: Upload Data from flat File [message #379556 is a reply to message #377374]

Wed, 07 January 2009 00:48

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Also research 'utl_file'.

David

Report message to a moderator

Previous Topic:	Upgrade from developer 2k to 6i problems
Next Topic:	FNDSCAUS LoV Personalization Error FRM-41826

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 02:34:00 CST 2025