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

  • End-user Training (John Watson)
  • Identify server requirements (John Watson)
  • Specify security authentication scheme(s) (John Watson)
  • Create pilot workspace (John Watson)

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;