Skip to Main Content

Overview

Dynamic Content region is based on Render dynamic content using PL/SQL Function Body returning a CLOB. With Dynamic Content Region you can control the region performance and contains support for MLE.

Set 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 Dynamic Content
    2. Find Appearance → Template, use Blank with Attributes

Demo

  • Create applications from spreadsheets (Pam King)
  • Lock spreadsheets (Pam King)
  • Send links to previous spreadsheet owners (Pam King)
  • Customize solutions (John Watson)

Sample Code

declare
    l_clob clob; 
begin
  l_clob := l_clob || '
    ';

  for c1 in ( select task_name, assigned_to
                from eba_ut_chart_tasks
               where rownum < 5 )
  loop
        l_clob := l_clob || '
  • ' || apex_escape.html(c1.task_name) || ' (' || apex_escape.html(c1.assigned_to) || ')
    • ';
  end loop;

  l_clob := l_clob || '
';

  return l_clob;
end;