Home » Developer & Programmer » Forms » Upload Data from flat File
Upload Data from flat File [message #377035] Fri, 19 December 2008 09:33 Go to next message
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.
Re: Upload Data from flat File [message #377056 is a reply to message #377035] Fri, 19 December 2008 12:00 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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.
Re: Upload Data from flat File [message #377076 is a reply to message #377035] Fri, 19 December 2008 21:37 Go to previous messageGo to next message
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
Re: Upload Data from flat File [message #377093 is a reply to message #377076] Sat, 20 December 2008 02:03 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
./fa/1600/0/ 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).
Re: Upload Data from flat File [message #377349 is a reply to message #377093] Mon, 22 December 2008 08:20 Go to previous messageGo to next message
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
Re: Upload Data from flat File [message #377374 is a reply to message #377349] Mon, 22 December 2008 10:18 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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.
Re: Upload Data from flat File [message #379556 is a reply to message #377374] Wed, 07 January 2009 00:48 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Also research 'utl_file'.

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


Current Time: Fri Dec 02 20:20:23 CST 2016

Total time taken to generate the page: 0.06573 seconds