OraLOB Schema Examples

The following schema objects are used in the OraLOB/BFILE examples. Run the SQL script ORAEXAMP.SQL) on your database to set up the schema.

CREATE TABLE part (

part_id NUMBER,

part_name VARCHAR2(20),

part_image BLOB,

part_desc CLOB,

part_collateral BFILE

);

Create Directory NewDirectoryName as 'C:\valid\path'