Skip to Main Content

Overview

PL/SQL Dynamic Content region is based on PL/SQL enable you to render any HTML or text using the PL/SQL Web Toolkit.

Set PL/SQL Dynamic Content as the Region type.

Instructions

  1. In Page Designer, select a region
  2. Go to the Property Editor
  3. Under the Region tab
    1. Find Identification → Type, use PL/SQL

Demo

  • Decommission servers (Al Bines)
  • Measure effectiveness of improved QA (Myra Sutcliff)
  • Response to Customer Feedback (Russ Saunders)
  • User acceptance testing (Russ Saunders)

Sample Code

declare

 cursor c_tasks is
   select task_name, assigned_to
     from eba_ut_chart_tasks
    where rownum < 5;
 
begin
  sys.htp.p('
    ');
  for a in c_tasks
  loop
    sys.htp.p('
  • ' || apex_escape.html(a.task_name) || ' (' || apex_escape.html(a.assigned_to) || ')
    • ' );
  end loop;
  sys.htp.p('
');
end;