Skip to Main Content

Document Generator Pre-Built Function

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!

HTML Data

BarryBMay 15 2025

Hi,

I have HTML data in the database which has been created with a rich text editor.

Example.

<h5>Challenges Addressed by Oracle AI</h5>
<p><strong>Missed revenue opportunities</strong>: Ineffective data analysis, content generation, and customer …

etc.

I have created a word document template which has this field.

I have some PL/SQL

Which creates JSON, then calls the function.

… --JSON

content_obj.put(v_data.code, v_data.content);

… --Call function

l_document := apex_print.generate_document(
p_data => l_data.to_clob,
p_template => l_template,
p_template_type => v_template_type_code,
p_output_type => v_output_type_code);

..

I'm wanting to produce a word document as output, which it does, but the HTML is produced verbatim.

Is there anything that I can do either in my template or in my PL/SQL to have the document display as it is in the application.

Thanks in advance,

Barry

This post has been answered by Francois Robert-Oracle on May 15 2025
Jump to Answer
Comments
Post Details
Added on May 15 2025
4 comments
149 views