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!

error with create object relational or binary xml

600930Jul 21 2008 — edited Jul 23 2008

hi guys
i register my schema but i'm trying to create xmltype as object relational but i got error as following
1 create table ORNS of xmltype
2 xmltype store as object relational
3 XMLSCHEMA "http://homepagezz.com/Movies.xsd"
4* ELEMENT "movies"
SQL> /
create table ORNS of xmltype
*
ERROR at line 1:
ORA-00902: invalid datatype

------------------------------

also when i create xmltype store as binary xml , i got error as the following

create table ORB of xmltype
xmltype store as binary xml
XMLSCHEMA "http://homepagezz.com/Movies.xsd"
ELEMENT "movies"

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2008

Added on Jul 21 2008

#performance-availability, #xml-db

8 comments

1,564 views