This discussion is archived
6 Replies Latest reply: Sep 29, 2011 5:59 AM by 875467 RSS

Redirect to URL from PL/SQL

temm Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points