OWA_PATTERN Error

From: Subbiah, Nagarajan <Nagarajan.Subbiah_at_aetn.com>
Date: Wed, 3 Aug 2005 12:22:18 -0400
Message-ID: <30462D80AA52E74698512ADCC4F7EAA3280A7C36@exchange.aetvn.com>

Hi,

We are running an update statement (stripping off all HTML tags from the not nullable clob and saving into another clob column, which can be null) and getting this error:

(Error): ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "SYS.OWA_PATTERN", line 885 ORA-06512: at "SYS.OWA_PATTERN", line 1128 ORA-06512: at "SYS.OWA_PATTERN", line 1165 ORA-06512: at "PPL.PPL", line 875

Any idea why? The length of the column is only 10,000. The works for the column length upto 10,000 and when the column length is close to 11,000 this throws an error.

Function which is called in the update statement:

Function : StripAllHTMLTags
--
Purpose : Remove All HTML tags
--

FUNCTION StripAllHTMLTags( p_HTMLString IN CLOB ) RETURN CLOB IS v_GoodHTML CLOB; BEGIN

v_GoodHTML := p_HTMLString;

      v_GoodHTML := REPLACE(v_GoodHTML, '&amp;', '&');
      v_GoodHTML := REPLACE(v_GoodHTML, '&nbsp;', ' ');
      v_GoodHTML := REPLACE(v_GoodHTML, ' &quot;', '''');

      OWA_PATTERN.CHANGE(v_GoodHTML, '<[^>]+>','','gi');
      OWA_PATTERN.CHANGE(v_GoodHTML, '\&[^;]+;', ' ', 'gi');


      RETURN v_GoodHTML;

END StripAllHTMLTags;

Thanks,
Raja

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 03 2005 - 11:24:24 CDT