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

i forgotten grant execute on XMLPARSER and XMLDOM to my user :)

slawek

Użytkownik "Sławomir Marcinkowski" <s.marcinkowski_at_Bankier.pl> napisał w wiadomości news:a3o7om$pgm$1_at_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;

>

>

>