6 Replies Latest reply: Sep 29, 2011 7:59 AM by 875467 RSS

    Redirect to URL from PL/SQL

    temm
      Hi,

      I'm trying to redirect to a url from an Application Process using
      DECLARE
      l_url varchar2(2000);
      BEGIN
      
      select APEX_UTIL.PREPARE_URL('f?p=&APP_ID.:10:&SESSION.:DELETELINE:&DEBUG.:RP:P10_ORID,P10_ORDID:&P10_ORID.,&PP10_CCODE.') into l_url from dual;
      
      htp.init();
      owa_util.redirect_url(l_url, true);
      
      END;
      The above process is called with javascirpt using ajax. This successfully deletes the item i want but first it returns this error
      (<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 
      and second it doesn't refresh the page.

      I'm using prepare_url since Page Protection is enabled with Arguments Must Have Checksum.