create or replace PROCEDURE my_image_display(p_image_id IN NUMBER)
AS
   l_mime        VARCHAR2 (255);
   l_length      NUMBER;
   l_file_name   VARCHAR2 (2000);
   lob_loc       BLOB;
BEGIN
   SELECT MIMETYPE, MYFILE, FILENAME, DBMS_LOB.getlength (MYFILE)
     INTO l_mime, lob_loc, l_file_name, l_length
     FROM PICTABLE
    WHERE ID = p_image_id;

   OWA_UTIL.mime_header (NVL (l_mime, 'application/octet'), FALSE);
   HTP.p ('Content-length: ' || l_length);
   OWA_UTIL.http_header_close;
   WPG_DOCLOAD.download_file (lob_loc);
END my_image_display;

</div><div class="rounded-corner-region" id="R7816020276921544" >
  <div class="rc-blue-top"><div class="rc-blue-top-r">
    <div class="rc-title">HTML</div>
    <div class="rc-buttons"></div>
  </div></div>
  <div class="rc-body"><div class="rc-body-r"><div class="rc-content-main"><img src="MY_IMAGE_DISPLAY?p_image_id=3"/></div></div></div>
  <div class="rc-bottom"><div class="rc-bottom-r"></div></div>
</div></td>
        <td class="tbl-sidebar"></td>     
      </tr>
    </tbody>
  </table>
</div><div id="footer"><div class="content">

create or replace
function                         wwv_flow_epg_include_mod_local(
    procedure_name in varchar2)
return boolean
is
begin
  --  return false; -- remove this statement when you modify this function
    --
    -- Administrator note: the procedure_name input parameter may be in the format:
    --
    --    procedure
    --    schema.procedure
    --    package.procedure
    --    schema.package.procedure
    --
    -- If the expected input parameter is a procedure name only, the IN list code shown below
    -- can be modified to itemize the expected procedure names. Otherwise you must parse the
    -- procedure_name parameter and replace the simple code below with code that will evaluate
    -- all of the cases listed above.
    --
    if upper(procedure_name) in (
          'MAGDBA.MY_IMAGE_DISPLAY', 'MAGDBA.SHOW_TABLE' ) then
        return TRUE;
    else
        return FALSE;
    end if;
end wwv_flow_epg_include_mod_local;

grant execute on apex_040000.wwv_flow_epg_include_mod_local to anonymous;