This discussion is archived
1 Reply Latest reply: Oct 3, 2013 12:20 AM by Moazam Shareef RSS

Cannot Upload or Display Image in blob Item.

Moazam Shareef Explorer
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points