Page 1 of 1

Inserting images

Posted: Fri Dec 05, 2008 7:16 am
by Pirzada
Hi All,
I have a table with an image column having data type long raw, i want to insert an image using INSERT statement,
INSERT INTO IMAGE_TABLE(ORG, IMG)
VALUES(82, ?? );
is it possible!

Posted: Thu Dec 11, 2008 4:04 pm
by tofeee
DECLARE
PICNO VARCHAR2(100);
BEGIN
PICNO := GET_FILE_NAME(FILE_FILTER=> 'JPG FILES (*.JPG)|*.JPG|'
||'BITMAP FILES (*.BMP)|*.BMP|');
IF PICNO IS NOT NULL THEN
READ_IMAGE_FILE(PICNO, 'ANY', 'image_name');
END IF;
END;


tofeee

Posted: Thu Dec 11, 2008 4:20 pm
by tofeee