dbms_xmlschema.generateschema
nicole4Feb 6 2004 — edited Feb 6 2004Hi!
I want to generate a XMLschema from the database but i only get this:
DBMS_XMLSCHEMA.GENERATESCHEMA(UPPER('SCOTT'),'EMPLOYEE_T').GETCLOBVAL()
--------------------------------------------------------------------------------
<?xml version="1.0"?>
<xsd:schema targetNamespace="http://ns.oracle.com/xdb/SCOT
This is my code:
select dbms_xmlschema.generateschema(upper('scott'), 'EMPLOYEE_T').getClobVal()
from dual;
This is my database:
9.2.0.1.0
Is my database the reason or have i done something wrong?
With best regards
Nicole