Re: call to createxml with a schema url does not create schema based xml

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 30 Jun 2005 10:51:57 -0700
Message-ID: <1120240323.508958_at_yasure>

justin.c.mays_at_gmail.com wrote:

> Our ultimate goal is to export
> information in xml format from the database.

http://www.psoug.org
click on Morgan's Library
click on DBMS_METADATA
scroll down to GET_XML

The syntax is:

dbms_metadata.get_xml(
object_type IN VARCHAR2,

name        IN VARCHAR2 DEFAULT NULL,
schema      IN VARCHAR2 DEFAULT NULL,
version     IN VARCHAR2 DEFAULT 'COMPATIBLE',
model       IN VARCHAR2 DEFAULT 'ORACLE',

transform IN VARCHAR2 DEFAULT NULL)
RETURN CLOB; This capability is already built into Oracle.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Thu Jun 30 2005 - 19:51:57 CEST