December 2002
Intermediate to advanced
745 pages
17h 26m
English
book
Oracle® Web Application Programming for PL/SQL® Developers
by Susan Boardman, Melanie Caffrey, Solomon Morse, Benjamin Rosenzweig
Content preview from Oracle® Web Application Programming for PL/SQL® Developers
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Unit 13.2. Storing and Retrieving Images in the Database
The process of uploading and downloading files to the database via the Web is dependent on a few key configuration settings for the DAD as well as the proper table in the database to store the files. There are many pros and cons associated with making a decision about saving files in the database or on the file system. Storing your image in the database will mean that you can back up your entire Web site all at once since the procedure that generates the Web pages and the image files are both in the database.
Setting Up the Database for File Storage
In order to store files in the database that the Oracle 9iAS can retrieve and understand, you must create a database table to store the images. ...