This content has been marked as final. Show 2 replies
The schema is registered as local.
here is the snippet to register the schema in SCHEMA2
xsd is a clob variable having the schema definition.
SCHEMAURL => 'http://myschema,
SCHEMADOC => xsd,
LOCAL => TRUE,
GENTYPES => TRUE,
GENTABLES => false);
DDL for table in SCHEMA1
CREATE TABLE SCHEMA1.TABLE_NAME(
ID NUMBER NOT NULL,
XML_COL XMLTYPE NOT NULL)
XMLTYPE COLUMN XML_COL