User's Manual

Using Oracle LOBs to Store and Load Employee Images

7-2 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft

In the SQL Commands page, enter the following CREATE TABLE statement:

CREATE TABLE employee_photos(

employee_id NUMBER,

employee_thumbnail BLOB);

Click Run:

6. In the Results section below the command text area, confirm that the table is

successfully created:

The HR user must have the CREATE TABLE privilege to perform this command. If

you get an "insufficient privileges" error message then logout as the HR user, login

as system with password manager and execute the following GRANT command:

GRANT create table TO hr;

Then login as HR again to execute the CREATE TABLE command.

7. Edit anyco_ui.inc. Add a Photograph column to the EMPLOYEES table in

ui_print_employees():