installing DBMS_XMLQUERY

[DBAwhosaysNIE]

all,

I have a 3rd party app that requires DBMS_XMLQUERY but I can't figure out how to install that package. I installed the XML options (they're on by default anyway) when I installed the software but when I grep DBMS_XML $ORACLE_HOME/rdbma/admin/* I get DBMS_XMLGEN, DBMS_XMLSTORE, DBMS_XMLPARSER, etc. (few others) but no DBMS_XMLQUERY.

I've poked around the online docs and see that DBMS_XMLQUERY is still supposed to be a valid package in 10 but can't find any installation instructions.

any help anyone may be able to provide would be greatly appreciated!

 

[HimanB]

Hi,
Execute DBMSXSU.SQL.
This script creates the following objects:

Object Name Object Type
==========================================
DBMS_XMLQUERY Package
DBMS_XMLQUERY Package Body
DBMS_XMLSAVE Package
DBMS_XMLSAVE Package Body

In oracle 8.1.7.x
The catxsu.sql script installs the Oracle XML SQL Utility (XSU) by loading classes

from the rdbms/jlib/xsu12.jar file. It then calls the dbmsxsu.sql and xmlgen.sql

subscripts to actually configure the PL/SQL objects needed for the XSU.

Objects loaded from ?/rdbms/jlib/xsu12.jar:

Object Name                       Java Class Name
=================================================== 

OracleXML                         OracleXML

OracleXMLStore                    OracleXMLStore

/20f12cf_OracleXMLSQLException    oracle/xml/sql/OracleXMLSQLException

/482ed896_OracleXMLSQLNoRowsEx    oracle/xml/sql/OracleXMLSQLNoRowsException

oracle/xml/sql/XSUMesg            oracle/xml/sql/XSUMesg

/61dfe75e_OracleXMLConvert        oracle/xml/sql/core/OracleXMLConvert

/6828f71c_OracleXMLTime           oracle/xml/sql/core/OracleXMLTime

/20109364_OracleXMLTimer          oracle/xml/sql/core/OracleXMLTimer

/3ad949fd_OracleXMLUtil           oracle/xml/sql/core/OracleXMLUtil

/a152eb84_OracleXMLDataSet        oracle/xml/sql/dataset/OracleXMLDataSet

/2d1ca5dd_OracleXMLDataSetExtJ    oracle/xml/sql/dataset/OracleXMLDataSetExtJdbc

/23714d96_OracleXMLDataSetGenJ    oracle/xml/sql/dataset/OracleXMLDataSetGenJdbc

/3ce8c9fc_OracleXMLSave           oracle/xml/sql/dml/OracleXMLSave

/f57715f1_OracleXMLStaticSaveM    oracle/xml/sql/dml/OracleXMLStaticSave$MutableInt

/7e1f2f8f_OracleXMLStaticSaveS    oracle/xml/sql/dml/OracleXMLStaticSave$SaveCtx

/5c4b55ba_OracleXMLStaticSave     oracle/xml/sql/dml/OracleXMLStaticSave

/b5bf304e_OracleXMLDocGen         oracle/xml/sql/docgen/OracleXMLDocGen

/4e2d263c_OracleXMLDocGenDOM      oracle/xml/sql/docgen/OracleXMLDocGenDOM

/72f0508e_OracleXMLDocGenLob      oracle/xml/sql/docgen/OracleXMLDocGenLob

/233ebe61_OracleXMLDocGenStrin    oracle/xml/sql/docgen/OracleXMLDocGenString

/1f249eae_OracleADTName           oracle/xml/sql/name/OracleADTName

/3f8bf704_OracleCollectionName    oracle/xml/sql/name/OracleCollectionName

/9001dfa7_OracleColumnName        oracle/xml/sql/name/OracleColumnName

/41ef4922_OracleCursorName        oracle/xml/sql/name/OracleCursorName

/6caec517_OracleScalarName        oracle/xml/sql/name/OracleScalarName

/52bed193_OracleXMLQuery          oracle/xml/sql/query/OracleXMLQuery

/c33162ba_OracleXMLStaticQuery    oracle/xml/sql/query/OracleXMLStaticQuery$MutableInt

/12249373_OracleXMLStaticQuery    oracle/xml/sql/query/OracleXMLStaticQuery$QueryCtx

/109a284b_OracleXMLStaticQuery    oracle/xml/sql/query/OracleXMLStaticQuery

 
Object Name                       Java Resource Name
========================================================
/84114dcb_XSUMessagespropertie    oracle/xml/sql/mesg/XSUMessages.properties

/ca4f65c8_XSUMessages_arproper    oracle/xml/sql/mesg/XSUMessages_ar.properties

/71be2f14_XSUMessages_caproper    oracle/xml/sql/mesg/XSUMessages_ca.properties

/878e4bec_XSUMessages_csproper    oracle/xml/sql/mesg/XSUMessages_cs.properties

/34f6d311_XSUMessages_daproper    oracle/xml/sql/mesg/XSUMessages_da.properties

/562950fb_XSUMessages_deproper    oracle/xml/sql/mesg/XSUMessages_de.properties

/6afc8c11_XSUMessages_elproper    oracle/xml/sql/mesg/XSUMessages_el.properties

/438530f4_XSUMessages_esproper    oracle/xml/sql/mesg/XSUMessages_es.properties

/d00855aa_XSUMessages_es_ESpro    oracle/xml/sql/mesg/XSUMessages_es_ES.properties

/133f577c_XSUMessages_fiproper    oracle/xml/sql/mesg/XSUMessages_fi.properties

/faa4f3d8_XSUMessages_huproper    oracle/xml/sql/mesg/XSUMessages_hu.properties

/37aea976_XSUMessages_itproper    oracle/xml/sql/mesg/XSUMessages_it.properties

/f7dd4db4_XSUMessages_iw_ILpro    oracle/xml/sql/mesg/XSUMessages_iw_IL.properties

/5fa58f38_XSUMessages_japroper    oracle/xml/sql/mesg/XSUMessages_ja.properties

/6520daf8_XSUMessages_koproper    oracle/xml/sql/mesg/XSUMessages_ko.properties

/992c5227_XSUMessages_nlproper    oracle/xml/sql/mesg/XSUMessages_nl.properties

/78cad057_XSUMessages_noproper    oracle/xml/sql/mesg/XSUMessages_no.properties

/a351a16c_XSUMessages_plproper    oracle/xml/sql/mesg/XSUMessages_pl.properties

/e59add9b_XSUMessages_ptproper    oracle/xml/sql/mesg/XSUMessages_pt.properties

/4b9e2bc1_XSUMessages_ru_RUpro    oracle/xml/sql/mesg/XSUMessages_ru_RU.properties

/521555c4_XSUMessages_skproper    oracle/xml/sql/mesg/XSUMessages_sk.properties

/b66edb7e_XSUMessages_svproper    oracle/xml/sql/mesg/XSUMessages_sv.properties

/ade9a7d6_XSUMessages_trproper    oracle/xml/sql/mesg/XSUMessages_tr.properties

/7b97f993_XSUMessages_zh_CNpro    oracle/xml/sql/mesg/XSUMessages_zh_CN.properties

/5e0d9d3b_XSUMessages_zh_TWpro    oracle/xml/sql/mesg/XSUMessages_zh_TW.properties

/318da4fc_XSUMesssages_frprope    oracle/xml/sql/mesg/XSUMesssages_fr.properties

/b0151e35_XSUMesssages_pt_BRpr    oracle/xml/sql/mesg/XSUMesssages_pt_BR.properties

/83ff37b0_XSUMesssages_ro_ROpr    oracle/xml/sql/mesg/XSUMesssages_ro_RO.properties

This script then calls the ?/rdbms/admin/dbmsxsu.sql and ?/rdbms/admin/xmlgen.sql scripts.

HTH
Regards
Himanshu

 

[DBAwhosaysNIE]

thatks but that script ( DBMSXSU.SQL) wasn't there...

I've actually been able to get the package installed by lowering myself to the most vile and offensive means possible:

Database Configuration Assistant

a GUI! (hanging my head in shame)

the plus side is it can spit our a sql file of what it did/ran so I shouldn't have to do this going forward.