Home » Developer & Programmer » Forms » Insert Image into BLOB Datatype and Retrieve In Oracle 6i (Oracle 6i and 10g)
icon8.gif  Insert Image into BLOB Datatype and Retrieve In Oracle 6i [message #656910] Sun, 23 October 2016 02:46 Go to next message
Mouzam
Messages: 1
Registered: October 2016
Junior Member
hey Developers,
I am New in oracle. please guide me.. how i can Upload image into oracle 6i form and Retrieve Image From BLOB Datatype.


Thanks In Advance;
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 Go to previous message
shahzad-ul-hasan
Messages: 615
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;  

Previous Topic: How to import excel file to oracle table in forms 10g
Next Topic: excel sheet
Goto Forum:
  


Current Time: Thu Mar 28 05:29:12 CDT 2024