insert image into blob in oracle 11g database
791246Jul 12 2011 — edited Jul 12 2011Hi,
I have created a table to insert images/text etc.
CREATE TABLE BLOB
( SERVICENUMBER NUMBER(16)
, BARCODE BLOB
, ADDRESS VARCHAR(26)
);
Now i need to insert the image through sql query.
I tried several ways but no result:
insert into BLOB values (1234567, FILETOBLOB("D:\pic1.jpeg","server"), 'ADDRESS1');
insert into BLOB values (1234567, BLOB("D:\pic1.jpeg","server"), 'ADDRESS1');
insert into BLOB values (1234567, 'D:\\pic1.jpeg', 'ADDRESS1');
*Can any body tell me how to insert the data into blob through SQL .*
Thanks.