This content has been marked as final. Show 2 replies
Did you register the XML Schema as local or global.
What is the code used to register the XML Schema
Waht is the DLL used to create the table.
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