I have a problem with downloading a static file. When i download a file from the application's static files i lose the file's name. The file name that i get on download is : wwv_flow_file_mgr.get_file - not very nice!
Here is my link code:
a href="#WORKSPACE_IMAGES#Form.doc">Download Form</a
Hi Vikas and Anyone else that reads this post,
After playing around with a few ideas i have managed to solve the problem! :)
Create a SQL report with the following definition:
select ID from htmldb_application_files where FILENAME = 'Form.doc'
Then in the report definition --> Report Attributes --> column attributes for ID column --> Column Formatting -->
Enter the following under the HTML Expression:
(a href ="p?n=#ID#" /)Download the Form(/a)
-- note: ( ) are actually < >
And you get the original filename from the download :)!
Good luck to every1,
I wish there was a way of giving you points for answering my question. Perfect answer and it seems some people are really hunting around and even creating their own procedures for this.
Spot on. Thank you so much!