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'; Grant read on directory <<directory>> to <<user>>; [9672_03_17.txt]
Where <<directory>>
is the name of the directory you want to create in the database. This is a virtual directory and you...