hello,
latest Developer and latest ( 10.2.0.3) version of server and client.
after XML schema registration, unable to issue " desc" on created tables:
:
select * from user_objects a
where upper(a.object_name) like 'TEST%'
OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
test286_T 55341 TYPE
test287_TAB 55342 55342 TABLE
test287_TAB$xd 55350 TRIGGER
SQL> desc "test287_TAB"
Object "test287_TAB" does not exist.
whereas in SQLplus :
SQL> desc "test287_TAB"
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLE of SYS.XMLTYPE(XMLSchema "http://localhost:8080/schemas/xsd/test.xsd" Element "test") STORAGE Object-relation
al TYPE "test286_T"
XSD :
forum software doesn't allow me to post actual xsd.
Thank you.
