Home » Developer & Programmer » Forms » Insert Image into BLOB Datatype and Retrieve In Oracle 6i (Oracle 6i and 10g)
|
Re: Insert Image into BLOB Datatype and Retrieve In Oracle 6i [message #659721 is a reply to message #656910] |
Sat, 28 January 2017 03:03  |
shahzad-ul-hasan
Messages: 643 Registered: August 2002
|
Senior Member |
|
|
Use This Code on Post Query at Form level.BLOB data can maximize your database size. The Database Will be havier for this. you can create folder on any driver and give this path to your image on form.
DECLARE
tiff_image_dir VARCHAR2(80) := 'D:\Photo\';
photo_filename VARCHAR2(80);
BEGIN
:System.Message_Level := '25';
photo_filename := tiff_image_dir||(:student.stuid)||'.JPG';
READ_IMAGE_FILE(photo_filename, 'JPEG', 'family.IMG'); ---On Form St and image and database field to null.
/* IF NOT FORM_SUCCESS THEN
MESSAGE('This Student does not have a photo on file.');
END IF;*/
:SYSTEM.MESSAGE_LEVEL := '0';
END;
|
|
|
Goto Forum:
Current Time: Wed Jun 11 22:33:02 CDT 2025
|