title: oracle apex redirect to modal dialoge page from pl/sql code
body: <p>I have a page process in my apex page. I want to redirect to a modal dialoge page after the page process finishes. So I wrote the code </p>
  
  <pre><code>htp.init;
  owa_util.redirect_url('f?p=&amp;APP_ID.:34:APP_SESSION.::NO:34:P34_CODE,P34_DAY_DATE:P30_CODE.,'||:P30_DAY_DT); 
  apex_application.stop_apex_engine;
  </code></pre>
  
  <p>The page 34 is a modal dialoge page . Hence it shows error</p>
  
  <blockquote>
    <p>page 34 cannot be rendered successfully. Ensure the page template in use on page 34 is of template type "Dialog page", with appropriate JavaScript dialog initialization, dialog closure and dialog cancel code defined.</p>
  </blockquote>
  
  <p>Then I tried with </p>
  
  <pre><code> l_url:=APEX_UTIL.PREPARE_URL('f?p=&amp;APP_ID.:34:APP_SESSION.::NO::P34_CODE,P34_DAY_DATE:P30_CODE.,'||:P30_DAY_DT',p_checksum_type=&gt;'SESSION'); 
   htp.init;
   apex_util.redirect_url(l_url);
   apex_application.stop_apex_engine;  
  </code></pre>
  
  <p>That too didn't worked for me. Anybody have solution?</p>