Sometimes it is very handy to be able to upload and download files in a web application. For example, an intranet site where users can upload their own images, or a product catalog with images of the products. We will create a web page where users can upload and download important documents such as templates of letters, fax sheets, telephone directories, and so on.
Make sure you have access to the
APP_DOCUMENTS table. Also make sure the directory parameter in the call to
bfilename points to an existing directory and that at least read access is granted. To create a directory with read access, execute the following commands (under the sys or system user) in sqlplus:
Create directory <<directory>> as 'c:\documents'; ...