Parse THIS!!! XML can't contain HTML (anchor tags)???

[jpollar]

Nope...didn't work.

I even tried changing it to a CLOB (see below + attachment).

Still getting this error.

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SASSOH.JOBS_BIFERT", line 5
ORA-04088: error during execution of trigger 'SASSOH.JOBS_BIFERT'
ORA-06512: at "SASSOH.LOADXML", line 3
ORA-06512: at line 22

When I take out the anchor tags and the CDATA, everything works perfectly.


--------------------------------------------------------------
CREATE OR REPLACE PROCEDURE LoadXML (cfxml in CLOB) AS
begin
insert into JOBS (xmldoc) values (xmltype.createxml(cfxml));
end;
/