Home » Server Options » Text & interMedia » how to upload TEXT FILE in a table?
how to upload TEXT FILE in a table? [message #76124] Thu, 23 September 2004 06:25 Go to next message
Messages: 34
Registered: September 2004
hi gurus!

i m facing a problem, i have different users and want to give them Developer 6i's form interface to upload their delimited TEXT FILES from their machines in a table, table is only one and all users are uploading their files.

once again, these files are on their own machines.

i hv Oracle 9i database & Developer 6i as front-end.

hope to receive a solution.



Re: how to upload TEXT FILE in a table? [message #76135 is a reply to message #76124] Tue, 09 November 2004 02:56 Go to previous message
Logesh D
Messages: 2
Registered: August 2004
Junior Member
step 1: send the user selected file to server side using FTP.
step 2: create directory name for server side location.
Step 3: using BFILENAME get a handle to the file and store file handler to BFILE.
Step 4: using DBMS_LOB.fileOpen, DBMS_LOB.loadFromFile load the file to clob or blob column of table.
Previous Topic: Prob: when creating context index
Next Topic: XML: where registering user defined attributes?
Goto Forum:

Current Time: Wed May 12 10:41:27 CDT 2021