SQL & PL/SQL

Hi all, i use a function to remove html tags and it's work fine except one thing. In the result occasionally i receive in addition to the result.

Function:

function remove_html_tags(p_task_memo in blob) return varchar2 is 
  
  begin 
  
  return replace(regexp_replace(utl_raw.cast_to_varchar2(p_task_memo), '<[^>]*>'), chr(13)||chr(10));
  end;

Result

удостоверение nbsp;

Expected result:

удостоверение ;

Any ideas?


Version:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
"CORE	11.1.0.7.0	Production"
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

Thanks in advance,
Bahchevanov.

Edited by: bahchevanov on Nov 16, 2011 1:58 AM

Edited by: bahchevanov on Nov 16, 2011 1:58 AM

Edited by: bahchevanov on Nov 16, 2011 1:59 AM

Edited by: bahchevanov on Nov 16, 2011 1:59 AM

Edited by: bahchevanov on Nov 16, 2011 2:00 AM