Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Display Only Markdown CLOB - PL/SQL: value or conversion error

Jon Dixon18 hours ago

I created a page item with the following key attributes: Display Only > Markdown > CLOB

If I then populate this Page Item with 100K characters in a Before Header Page Process e.g.
declare
l_chunk varchar2(32767);
l_clob clob;
begin
-- 32k-ish chunk
l_chunk := rpad('x', 32767, 'x');
dbms_lob.createtemporary(l_clob, true);
-- 100,000 chars total (3 * 32767 = 98301) + 1699 = 100000
for i in 1 .. 3 loop
dbms_lob.writeappend(l_clob, length(l_chunk), l_chunk);
end loop;
dbms_lob.writeappend(l_clob, 1699, rpad('y', 1699, 'y'));
-- Populate the APEX page item
:P3_MARKDOWN_CLOB := l_clob;
dbms_lob.freetemporary(l_clob);
end;

Run the page, and I get this error:

If I change the Format to Plain Text, it works fine.

Other notes

  • This error also happens if you set the Item Type to Markdown Editor, and set the Read Only attribute to Always.
  • Works fine for Type = Markdown Editor and not display only.
Comments
Post Details
Added 18 hours ago
2 comments
35 views