1 Reply Latest reply: Oct 3, 2013 2:20 AM by Moazam Shareef RSS

    Cannot Upload or Display Image in blob Item.

    Moazam Shareef

      Hi Guyz,

       

      I'm inserting a image in a blob item using oracle forms 10g and database 9i, everything is working fine except uploading image, i tried the below code it was opening file Open dialog and as soon as i select the image to insert into the image item it will not shown anything at all in image item.

      WBP trigger code.

      [code]

      DECLARE

      FILENAME VARCHAR2(256);

      BEGIN

      FILENAME := WEBUTIL_FILE.FILE_OPEN_DIALOG();

      IF FILENAME IS NOT NULL THEN

        CLIENT_IMAGE.READ_IMAGE_FILE(FILENAME,SUBSTR(FILENAME,INSTR(FILENAME,-1)),'MN_PICTURES.PICTURE');

        :MN_PICTURES.PIC_STAT:=1;

      END IF;

      END;

      [/code]

       

      then i tried new thin from scratch using the below link to insert the code but still same i cannot insert image into the image item i set the below properties in image item

      Baig's Technology Blog: Storing and Retrieving Images / Word / Excel / PDF and Movies in Oracle Database using Forms10g

      sizing style=Adjust

      Image format= TIFF.

      any patch required or i'm doing something wrong?

       

      Regards

      Moazam