Unanswered: How to copy a file from client to a server in oracle forms
Hi ... I have a simple question and i found no answer for my case ... i have an excel file on client machine and i want to copy it to database server (not to table in database but to its drive C:\)using oracle forms ...
-i found webutil library but i didn't find a function for my case although there are several functions to transfer like : as_to_client, client_to_as ...
-also i found DBMS_FILE_TRANSFER package but unfortunately it's suitable for transferring files between two directories in the same database server.
and thank u for ur help
"...I think it is much easier to use the webutil file_transfer package
to copy files from the client to the database server..."
Sorry if I did not follow the entire post, but it is a fact that you won't, never, send anything to the database server with Webutil with transfert function. You can send a file to the A.S. machine or inside a database BLOB column, but not directly to the machine that hosts the database.
For that purpose, you have to store the file in the database, then use the UTL_FILE to output the file to a database server machine disk.
Besides, did you consider FTP itself? Write a batch script that would do the FTP and call that script from your form (using CLIENT_HOST).