CREATE OR REPLACE PROCEDURE raise_no_access(url in varchar2) as
 
BEGIN
 
      htp.htmlOpen;
      htp.headOpen;
      htp.print('<META HTTP-EQUIV="Pragma" CONTENT="no-cache">');
      htp.print('<META HTTP-EQUIV=REFRESH
        CONTENT="3;URL='||owa_util.get_owa_service_path||url||'">');
      htp.headClose;
      htp.bodyOpen('/ows-img/raj/fleck.jpg');
      htp.centerOpen;
      htp.print('
        <table border=0 cellpadding=5 cellspacing=5 width=508 height=90%>
<tr valign=middle>
                <th colspan=2>
                        <font face="Arial, Helvetica" size="5">
                        We''re Sorry, We Cannot<br>
                        Process Your Request
                        </font>
                </th>
        </tr>
        <tr align="center">
                <td>
 
                </td>
        </tr>
        <tr valign=middle>
                <td align=center><font face="Arial, Helvetica" size="3">
                Reason: </font>
                        <font face="Arial, Helvetica" size="3"
color="#ff0000"><b>No Access / Logged out.  Please re-login.</b></font><br>
         </td>
         </tr>
         </table>');
         htp.para;
         htp.fontOpen(null,'Arial, Helvetica','3');
 htp.print('Back to '
        ||  htf.anchor(owa_util.get_owa_service_path ||url,url));
         htp.fontClose;
         htp.centerClose;
         htp.bodyClose;
         htp.htmlClose;
End;
/
show errors
  
CREATE OR REPLACE procedure goback (n in varchar2 default -1,
                  description in varchar2 default 'Back to Previous Section')
                as
begin
  htp.para;
  htp.print('<form><input type=button value="'||description||'"
        OnClick=history.go('||n||')></form>');
end goback;
/
show errors 
