-- run as the portal30 user

whenever sqlerror continue;

drop public synonym "org/w3c/dom/Node";
drop public synonym "org/w3c/dom/NodeList";
drop public synonym "org/w3c/dom/Element";
drop public synonym "oracle/xml/parser/v2/XMLDocument";
drop public synonym "org/w3c/dom/DOMException";
drop public synonym "org/w3c/dom/NamedNodeMap";
drop public synonym "oracle/xml/parser/v2/DOMParser";
drop public synonym "oracle/xml/parser/v2/XMLNode";

whenever sqlerror exit;

create public synonym "org/w3c/dom/Node" for "org/w3c/dom/Node";
create public synonym "org/w3c/dom/NodeList" for "org/w3c/dom/NodeList";
create public synonym "org/w3c/dom/NamedNodeMap" for "org/w3c/dom/NamedNodeMap";
create public synonym "org/w3c/dom/Element" for "org/w3c/dom/Element";
create public synonym "oracle/xml/parser/v2/XMLDocument" for "oracle/xml/parser/v2/XMLDocument";
create public synonym "org/w3c/dom/DOMException" for "org/w3c/dom/DOMException";
create public synonym "oracle/xml/parser/v2/DOMParser" for "oracle/xml/parser/v2/DOMParser";
create public synonym "oracle/xml/parser/v2/XMLNode" for "oracle/xml/parser/v2/XMLNode";


grant execute on "org/w3c/dom/Node" to public;
grant execute on "org/w3c/dom/NodeList" to public;
grant execute on "org/w3c/dom/NamedNodeMap" to public;
grant execute on "org/w3c/dom/Element" to public;
grant execute on "oracle/xml/parser/v2/XMLDocument" to public;
grant execute on "org/w3c/dom/DOMException" to public;
grant execute on "oracle/xml/parser/v2/DOMParser" to public;
grant execute on "oracle/xml/parser/v2/XMLNode" to public;

exit;