select 
i.RN,
i.TITLE_NEWS,
i.NEWS,
'<img src="p?n=' || nvl(i.FILE_BLOB, 0 ) || '" height="50" width="50" />'
from   "NEWS" i

create or replace procedure P_IMG_S(
nRN    in  number
) is
   l_mime        VARCHAR2 ( 255 );
   l_length      NUMBER;
   l_file_name   VARCHAR2 ( 2000 );
   lob_loc       BLOB;
BEGIN
   SELECT t.jpg_mimetype, t.jpg_blob, t.jpg_filename, DBMS_LOB.getlength (t.jpg_blob)
     INTO l_mime, lob_loc, l_file_name, l_length
     FROM news t
    WHERE t.rn = nRN;

   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 P_IMG_S;

GRANT EXECUTE ON P_IMG_S TO PUBLIC;
CREATE PUBLIC SYNONYM P_IMG_S FOR pa.P_IMG_S;

<img src="#OWNER#.p_img_s?nrn=1" />

 403  Forbidden
You don't have permission to access /w/p_img_s on this server.

p_img_s - в какой схеме создан ?

В свойствах DAD...

create or replace procedure P_X(
sVar in varchar2
) is
begin
  htp.p('hello world'||nvl(sVar, '1111111'));
end P_X;

grant execute on P_X to public;

Forbidden
You don't have permission to access /w/pro.p_x on this server.

Oracle-Application-Server-10g/ 10 . 1 . 2 . 0 . 0  Oracle-HTTP-Server Server at хххх.хххх.ххх.ru Port  80 

create or replace function flows_030100.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 (
          '') then
        return TRUE;
    else
        return FALSE;
    end if;
end wwv_flow_epg_include_mod_local;

create or replace function flows_030100.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 (
          'PRO.P_IMG_S',
          'PRO.P_X',
          ) then
        return TRUE;
    else
        return FALSE;
    end if;
end wwv_flow_epg_include_mod_local;