Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_xmlschema.generateschema

nicole4Feb 6 2004 — edited Feb 6 2004
Hi!
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2004
Added on Feb 6 2004
1 comment
359 views