Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> i have a some problem in Oracle XML DB(Schema register)
Hello everyone,
I'm experiencing a very nasty problem while working with the XML
functionalities of Oracle 9iR2. Indeed, I receive error ORA-31079: type
"TextualType" ... when I try
to insert in my table a valid XML document containing floats.
With the following ( W3C schema for Mpeg7 ) example, the error still occurs:
SQL> begin
2 dbms_xmlschema.registerSchema 3 ( 4 'http://shlee:8080/home/SCOTT/xsd/Mpeg7-t.xsd', 5 xdbURIType('/home/SCOTT/xsd/Mpeg7-t.xsd').getClob(),6 True,True,False,True
ORA-31079: type "TextualType"¿¡ ´ëÇÑ ÂüÁ¶¸¦ ºÐ¼®ÇÒ ¼ö ¾øÀ½ ORA-06512: "XDB.DBMS_XMLSCHEMA_INT", ÁÙ 0¿¡¼ ORA-06512: "XDB.DBMS_XMLSCHEMA", ÁÙ 26¿¡¼ ORA-06512: ÁÙ 2¿¡¼Received on Mon Sep 13 2004 - 06:12:30 CDT
![]() |
![]() |