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

[jpollar]

It doesn't do me any good if I can't call the procedure.

The error is coming from the 5th line in the trigger....and the 3rd line of the procedure.

The assignment statement in the call is not causing an error.

CREATE OR REPLACE TRIGGER jobs_bifert
before insert on jobs
for each row
begin
if (:new.xmldoc is null) then
return;
end if;
select
xmltype.getstringval(:new.xmldoc.extract('/recordset/row/title/text()')),
xmltype.getstringval(:new.xmldoc.extract('/recordset/row/company/text()')),
xmltype.getstringval(:new.xmldoc.extract('/recordset/row/location/text()'))
into :new.title, :new.company, :new.location
from dual;
end;

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