DBMS_XMLSCHEMA.GENERATESCHEMA and ORA-21500

You may run into this error. You want to generate an xsd based on on object type. You create the object: CREATE OR REPLACE TYPE my_test_typeAS OBJECT (EMPLOYEE_ID NUMBER(6),FIRST_NAME VARCHAR2(20)); Then you want to get the associated xsd: SQL>...