Insert an image file into oracle and open image file from database?(using sql)

[Sri Dharan]

Hello,

I want to insert an image file ino oracle 9i using BLOB (without using pl/sql ,any thing) using normal sql;

I have created table as below:
CREATE TABLE test_blob (id NUMBER(15),image_name VARCHAR2(1000),image BLOB);


But I am not able to insert image file.Could you please help me in this regarding?And how to get image file using jsp ,jdbc?


thanks & regards
Sri

[Paul Campbell]

You should be able to find an example here:

http://www.oracle.com/technology/sample_code/tech/java/sqlj_jdbc/htdocs/templates.htm