OWA_PATTERN Error
- From: "Subbiah, Nagarajan" <Nagarajan.Subbiah@xxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 3 Aug 2005 12:22:18 -0400
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, '&', '&');
v_GoodHTML := REPLACE(v_GoodHTML, ' ', ' ');
v_GoodHTML := REPLACE(v_GoodHTML, ' "', '''');
OWA_PATTERN.CHANGE(v_GoodHTML, '<[^>]+>','','gi');
OWA_PATTERN.CHANGE(v_GoodHTML, '\&[^;]+;', ' ', 'gi');
RETURN v_GoodHTML;
END StripAllHTMLTags;
Thanks,
Raja
--
//www.freelists.org/webpage/oracle-l
Other related posts:
