How to insert BLOB field into the table?

I created a table that has BOLB as datatype as shown below.

SQL> desc candidate_bio;

 Name                                Null?    Type
------------------------------------ -------- ----------
 CANID                                        NUMBER
 RESUME                                       BLOB
 PHOTO                                        BINARY FILE LOB

SQL> select * from candidate_bio;
SP2-0678: Column or attribute type can not be displayed by SQL*Plus

Can somebody tell me how can I insert BLOB data(resume and photo) to this table, and browse it?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Oct 24 1999 - 16:08:31 CDT