Problem Description

Images are appearing blurry while accessing TIG link

Steps to Resolve

1. The real longer-term fix is to convert all of the images from jpg’s to bmp’s – then modify the xna_hpms_ui package code to call the bmp's
2. Workaround is replace procedure get_image with below fix and recompile.

PROCEDURE get_image (p_name  IN  nm_upload_files.name%TYPE, p_type  IN  VARCHAR2 DEFAULT 'jpeg') IS

t_blob          BLOB;

t_amt           NUMBER := 30;

t_off           NUMBER := 1;

t_raw           RAW(4096);

t_type        VARCHAR2(20);

t_name        VARCHAR2(30);

CURSOR cur_image(cp_name IN VARCHAR2, cp_type IN VARCHAR2) IS

  SELECT hu_image_contents

  FROM   hpms_ui

  WHERE  hu_file_name = cp_name

    AND hu_type = cp_type;

BEGIN

    t_type        := 'image/' || p_type;

    t_name        := p_name;

    OPEN cur_image(t_name, t_type);

    FETCH cur_image INTO t_blob;

    CLOSE cur_image;

    OWA_UTIL.mime_header(t_type);

    HTP.p('Content-Length: ' || DBMS_LOB.getlength(t_blob));

    OWA_UTIL.http_header_close;

    WPG_DOCLOAD.download_file(t_blob);

END;