Is there an easy way to have a stored procedure download a file from an oracle directory.
I create a directory like so:
create or replace directory MY_DIR as '/tmp'
/
I place a file in it: data.csv
I have a button on a page with a link target of url and a url like: #OWNER#.download_csv('data.csv')
I have tried to use the howto on uploading and downloading files as a guide. But I'm trying to avoid having to create a table to first upload my file into before downloading.
Any ideas?