Skip to Main Content
Forums

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!

problem in creating XMLTYPE table using schema validation

Vikas KumarNov 22 2007 — edited Nov 28 2007
Hi All,

While executing  the follwing script there is an error :
Script : " CREATE TABLE FINAPI_ONLINE_SEC_LOGIN_TMP1 OF   
              SYS.XMLTYPE XMLSCHEMA
              "http://www.finnone.com/xsd/TransactionDataRequest.xsd"
               ELEMENT "transactiondatarequest"

Error is :

ERROR at line 1:
"ORA-31000: Resource 'http://www.finnone.com/xsd/BaseSchema.xsd' is not an XDB schema document"

why this problem is coming though transactiondatarequest.xsd is reguisterd

Regards,
Vikas Kumar
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2007
Added on Nov 22 2007
#performance-availability, #xml-db
10 comments
1,917 views