APEX 21.2渲染PL/SQL动态内容区域遇ORA-22835错误求助

问题背景 #

在APEX课程详情模态页的PL/SQL动态内容区域，渲染时偶尔触发以下错误：

ERROR: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4270, maximum: 4000)
Error: Error during rendering of region "Course Details".

经排查错误源于htp.p(l_html_clob)将CLOB转换为VARCHAR2时超出缓冲区上限，需要替代方案处理大CLOB内容。

动态生成的HTML示例：

<div class="course-output">
    <div class="course-hide-content" course-subtitle-original>Level 1</div>
    <div class="course-hide-content" course-group-others></div>
    <div class="course-details">
        <div class="course-group-name">Fine Arts: Music</div>
        <div class="title-number">Intermediate Band (923310)</div>
        <div class="course-subtitle"></div>
        <div class="course-metadata">
            <div class="course-meta-data-row"><span>Grades:</span><span>7, 8</span></div>
            <div class="course-meta-data-row"><span>Credits:</span><span>non-credit</span></div>
            <div class="course-meta-data-row"><span>Academic Type:</span><span>None Listed</span></div>
            <div class="course-meta-data-row"><span>Prerequisite:</span><span>Successful audition</span></div>
        </div>
    </div>
    <div class="course-description">
        <span class="course-description">Intermediate level band students will continue to
            develop skills on woodwind, brass, or percussion instruments. A variety of musical styles will be studied
            through the playing of band literature. Students must meet both the school day and outside of the school day
            participation requirements to receive credit for the course. This course requires a student materials fee as
            listed in FCPS Notice 5922.</span>
        <span course-description-append></span>
    </div>
</div>

内容的提问来源于stack exchange，提问作者McRivers