 |
|
Oracle Tips by Burleson |
Oracle 10g New Package dbms_aw_xml
The dbms_aw_xml contains the following functions:
-
validate – This function verifies
that the XML provided by the user is well-formed and is ready
for execution. It checks that all the implicit AW constraints
are met.
-
interpret – This function interprets
the input and makes changes to the AW named ‘awname’. If there
is no AW named awname, one is created by this function.
INTERPRET accepts the users XML and calls the aw_create olap dml
package to create the AW and perform the specific calculations
-
describe - This function allows the
users to examine the contents of the AW. It takes the awname as
the input and outputs the information as XMLType. If the input
is provided, it outputs the information about all AW objects.
Prior to 10g, the cwm_to_ecm olap dml package
used to read the metadata from the cwm lite catalog and used it to
create an Analytic Workspace. This package can now read XML metadata
and produce corresponding Analytic Workspace/s. It indicates that
the Analytic Workspace created by CwM metadata and produced from the
XML metadata have the same structure and follows the same
conventions.
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
