21.18 JSON_CLOB Function

This function returns p_string with all special characters escaped.

Syntax

APEX_ESCAPE.JSON_CLOB (
    p_string    IN CLOB )
    RETURN CLOB;

Parameters

Table 21-20 JSON_CLOB Parameters

Parameter	Description
p_string	The string to be escaped.

Example

The following example prints this: { "name": "O\u0027Brien"}

DECLARE
    l_string clob := 'O''Brien';
BEGIN
    sys.htp.p('{ "name": "' || apex_escape.json_clob(l_string) || '"}');
END;