Oracle 10g Developing Media Rich Applications

Chapter 5. Introduction to interMedia APIs

In this chapter we will introduce interMedia APIs with simple examples. We will use the various APIs to load an image, convert that image to a smaller size image and store the thumbnail in the database, and retrieve the image and store it in a local file.

PL/SQL

Preparation

To prepare the database for interMedia file operations, the user schema must be assigned the privileges to access files and create files. Before a file can be accessed, a database directory object must be created, and access to that directory object must be granted to the database user. From a system administrator account, the following PL/SQL steps are used to prepare the user Scott for file input and output operations:

• Create or replace ...