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

[TimHall]

Strange. This works fine for me:

DECLARE 
  CFXML VARCHAR2(32767);

BEGIN 
  CFXML := '
<row>
<date>
<![CDATA[ Jul 27 ]]>
</date>
<title>
<![CDATA[ ><a href="http://jobsearch.monster.com:80/getjob.asp?JobID=32472300' || CHR(38) || 'AVSDM=2005%2D07%2D28+02%3A36%3A26' || CHR(38) || 'Logo=1' || CHR(38) || 'q=cold fusion' || CHR(38) || 'cy=US' || CHR(38) || 'sort=dt">ASP.NET Technical Program Manager with Marketing Savvy</a> ]]>
</title>
<company>
<![CDATA[ Excell Data ]]>
</company>
<location>
<![CDATA[ ><a onClick="popMMLL(''WA'',''Redmond''); return false;" href="http://jobsearch.monster.com:80/896">WA-Redmond</a> ]]>
</location>
</row>
</recordset>';

  --SASSOH.LOADXML ( CFXML );
  COMMIT; 
END; 
/

Notice, I've commented out the procedure call as the error is at line 5 which is the variable assignment in the PL/SQL block, not the procedure.

Cheers

Tim...