I can't use xmlparser.PARSER in trigger in my database 9i

From: Sławomir Marcinkowski <s.marcinkowski_at_Bankier.pl>
Date: Tue, 5 Feb 2002 10:14:41 +0100
Message-ID: <a3o7om$pgm$1@news.tpi.pl>

I tried to make triger from
http://www.oracle.com/oramag/oracle/01-nov/index.html?o61xml.html like this one at end of this message. Unfortunently when I try to compile this trigger I always get messages like this:

2/11     PLS-00201: identifier 'XMLPARSER' must be declared
2/11     PL/SQL: Item ignored
4/17     PLS-00201: identifier 'XMLDOM' must be declared
4/17     PL/SQL: Item ignored
8/5      PLS-00320: the declaration of the type of this expression is
         incomplete or malformed

Does anybody know what to do?

slawomir marcinkowski

---

---

create or replace trigger ARTICLEVALIDATION before insert on ARTICLESXML
for each row
declare

   PARSER xmlparser.PARSER;
   DTD_SOURCE clob;
   DTD_DOCUMENT xmldom.DOMDocumentType;
begin

    select DTD into DTD_SOURCE from DTDSTORE where DOCTYPE = 'ARTICLE';

    PARSER := xmlparser.newParser;
    xmlparser.setValidationMode( PARSER , false);

    xmlparser.parseDTDClob( PARSER , DTD_SOURCE , 'article' );     DTD_DOCUMENT := xmlparser.getDoctype( PARSER );

    xmlparser.setValidationMode( PARSER , true );     xmlparser.setDoctype( PARSER , DTD_DOCUMENT );

    xmlparser.parseClob( PARSER , :new.ARTICLE.getClobVal() ); end; Received on Tue Feb 05 2002 - 03:14:41 CST