Saving File to Client PC
770225Jun 14 2010 — edited Jun 14 2010Hi All,
-----------------
Forms [32 Bit] Builder Version 9.0.4.0.19
Application Server 9.0.4.0.0
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0
-----------------
I’m creating a form that would allow a user to save a file to a server on the network (or their PC) and I can’t find way to do this.
The two methods I have tried are:
1) Using UTL_FILE in a stored procedure
2) Creating a Java stored procedure (and a wrapper procedure in PL/SQL)
And then calling either of these procedures from the form. In both cases the file is written to the server. As far as I understand this is how UTL_FILE has been designed. However, if I understand correctly, the Java option does allow you to access the local file system. Can you please given an example or some guidance on how I can do this? Is it something to do with the users Java Home? I am not a Java expert so do try be as descriptive as possible!
The alternative would be to save the file to the server and create an FTP account for the user to access/transfer the file.
Thanks!