Setting Up the Environment
Since the three XML PL/SQL packages are created during the database installation, you do not need to perform additional setup. During the creation of the three PL/SQL packages, public synonyms—XMLPARSER, XMLDOM, and XSLPROCESSOR—are created for DBMS_XMLPARSER, DBMS_XMLDOM, and DBMS_XSLPROCESSOR, respectively, to substitute for the XMLPARSER, XMLDOM, and XSLPROCESSOR packages in Oracle9i Database. The execution privileges of the XML PL/SQL packages are also granted to PUBLIC, which means all users by default are able to run these packages. If you have any security concerns, you need to withdraw these privileges from PUBLIC and grant them to specific users.To check whether you can run the PL/SQL packages, you can use the following SQL command:SQL> desc <PL/SQL package name>
For example, you can check whether you can run the DBMS_XMLPARSER package by using the following command:
SQL> desc DBMS_XMLPARSER
If you have the execution privilege, you will see the definitions of the procedures and functions defined in the DBMS_XMLPARSER package.