function get_html_with_line_breaks

function get_html_with_line_breaks(
    p_html in varchar2
) return varchar2

replace normal line breaks with html line breaks

function add_hyperlinks

function add_hyperlinks(
    p_text in varchar2,
    p_class in varchar2:=null
) return varchar2

make URLs in text into hyperlinks

function add_hyperlinks

function add_hyperlinks(
    p_text in clob,
    p_class in varchar2:=null
) return clob

make URLs in text into hyperlinks