Hi,

I'm trying to register 2 schemas(brother.xsd & sister.xsd) importing each other.
# I mean brother.xsd imports sister.xsd and vise versa.
I used force option of "dbms_xmlschema.registerSchema" to do it, but it doesn't work well.

* environment
Oracle XML DB 9i (9.2.0.4.0)
Windows NT

The SQL code and an error message are the following.

SQL ==============================================
Set echo on
alter session Set events='31098 trace name context forever';

call dbms_xmlschema.registerSchema
(
'brother.xsd',
xdbURIType('/home/Family/brother.xsd').getClob(),
True, True, False, True, True
);

call dbms_xmlschema.registerSchema
(
'sister.xsd',
xdbURIType('/home/Family/sister.xsd').getClob(),
True, True, False, True, True
);

Error message ====================================
SQL> call dbms_xmlschema.registerSchema
2 (
3 'brother.xsd',
4 xdbURIType('/home/Family/brother.xsd').getClob(),
5 True, True, False, True, True
6 );
True, True, False, True, True
*
ERROR at line 5:
ORA-06576: not a valid function or procedure name.

SQL> call dbms_xmlschema.registerSchema
2 (
3 'sister.xsd',
4 xdbURIType('/home/Family/sister.xsd').getClob(),
5 True, True, False, True, True
6 );
True, True, False, True, True
*
ERROR at line 5:
ORA-06576: not a valid function or procedure name.


Which one is a mistake?
Please help me><
Any comments will be appreciated.