All Forums Database
21 Nov 2014
Not able Insert LOB

Hello All,
I am trying to insert a image in the DB. Follow is the DDL:
CREATE TABLE DB.Sample3
(
ID INT GENERATED ALWAYS AS IDENTITY(START WITH 1 INCREMENT BY 1),
Image BLOB(9000)
);
 
INS INTO DB.Sample3 values(,?B); (Trying to insert a image from the windows pictures)
SEL* FROM DB.Sample3;
 
A pop-up comes asking for the path. When i give the path, i get a error as object not found.
Error msg:
Insert Failed. 3807: Object 'Penguins' does not exists.
 
 
Please Help.
Thanks in Advance
Jugal.
 

Tags:
You must sign in to leave a comment.