Inserting images

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
Pirzada
Posts: 30
Joined: Fri Dec 07, 2007 2:04 am
Location: Pakistan

Inserting images

Post 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!
tofeee
Posts: 3
Joined: Thu Dec 11, 2008 3:21 pm
Location: Saudi Arabia

Post 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
tofeee
Posts: 3
Joined: Thu Dec 11, 2008 3:21 pm
Location: Saudi Arabia

Post by tofeee »

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest