I'm trying to determine why subtype creation is not working in 11G R2 XE, while it works in 11G R2 EE.
Environment is XE 126.96.36.199 on Windows 7 X64 (yes, not supported but I don't have anywhere else to try this).
Here is a test case, using the SYSTEM account as that is what the developers use (yes, terrible practice) :
-- this works, creates the type
CREATE OR REPLACE TYPE [schema].prod_type AS OBJECT (
MEMBER PROCEDURE display(pid IN NUMBER))
NOT INSTANTIABLE NOT FINAL;
-- this doesn't work, it creates the type "deal_type" separately
CREATE OR REPLACE TYPE [schema].deal_type UNDER prod_type (
I've tried adding the schema name after UNDER, e.g. UNDER [schema].prod_type with the same result.