HTML_TRUNC Function Signature 1

This function escapes HTML and limits the returned string to p_length bytes. This function returns the first p_length bytes of an input VARCHAR2 and escapes them. You can use this function if the input VARCHAR2 is too large to fit in a VARCHAR2 variable and it is sufficient to only display the first part of it.

Syntax

APEX_ESCAPE.HTML_TRUNC (
    p_string    IN VARCHAR2,
    p_length    IN NUMBER   DEFAULT 4000 )
    RETURN VARCHAR2;

Parameters

Parameter	Description
p_string	The text string that is escaped.
p_length	The number of bytes from p_string that are escaped.

Example

This example generates a html list of of titles and text bodies. HTML entity attributes are escaped with HTML_ATTRIBUTE, whereas normal text is escaped with HTML and HTML_TRUNC.

BEGIN
    htp.p('<ul>');
    for l_data in ( select title, cls, body
        from my_topics )
    LOOP
    sys.htp.p('<li><span class="'||
        apex_escape.html_attribute(l_data.cls)||'">'||
        apex_escape.html(l_data.title)||'</span>');
    sys.htp.p(apex_escape.html_trunc(l_data.body));
    sys.htp.p('</li>');
    END LOOP;
    htp.p('</ul>');
END;

See Also:

• SET_HTML_ESCAPING_MODE Procedure