Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> i have a some problem in Oracle XML DB(Schema register)

i have a some problem in Oracle XML DB(Schema register)

From: À̼øÈñ <shlee_at_act.ac.kr>
Date: Mon, 13 Sep 2004 20:12:30 +0900
Message-ID: <ci3v4u$3l$1@news1.kornet.net>


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
  7 );
  8 End;
  9 /
   begin
*
Error line-1:
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US