21.13 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 CLOB and escapes them. You can use this function if the input CLOB 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 CLOB,
p_length IN NUMBER DEFAULT 4000 )
return VARCHAR2;
Parameters
Table 21-14 HTML_TRUNC 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:
Parent topic: APEX_ESCAPE