OraFAQ Forum: Forms » I am unable to insert image file while using BLOB Data type with the following code:

Home » Developer & Programmer » Forms » I am unable to insert image file while using BLOB Data type with the following code:

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I am unable to insert image file while using BLOB Data type with the following code: [message #381930]

Tue, 20 January 2009 06:00

mnashraf
Messages: 1
Registered: January 2009
Location: Karachi

Junior Member

I am unable to insert image file while using BLOB Data type with the following code:
GO_ITEM('EMP_TEST.BLOB_PIC');
DECLARE
Emp VARCHAR2(100);
BEGIN
Emp := 'D:\Famco\scott_pic\' || :empno||'.jpg';
Read_Image_File(Emp, 'JPG', 'EMP_TEST_BLOB.BLOB_PIC');
IF NOT Form_Success
THEN
Message('There is no such picture');
Message('There is no such picture');
ELSE
DECLARE
Ia VARCHAR2(255);
Path1 VARCHAR2(100);
BEGIN
Path1 := 'D:\Famco\scott_pic\';
Ia := Get_File_Name(Path1,
File_Filter => 'JPG Files (*.jpg)/*.jpg/ All Files (*.*)/*.*/');
Read_Image_File(Ia, 'JPG','EMP_TEST_BLOB.BLOB_PIC');
END;
END IF;
END;
The image displayed into image container in forms6i and when I prssed save button it showed me that record has been saved but when I querried again after clearing record no image displayed and I noticed it did not go to database actually.
I am using Oracle Forms
Forms [32 Bit] Version 6.0.8.11.3
Oracle9i Enterprise Edition Release 9.2.0.1.0
Please help me in this regard.