This discussion is archived
1 Reply Latest reply: Jun 4, 2013 4:06 PM by user10205865 RSS

Help - Subtypes created incorrectly as types in 11G R2 XE

user10205865 Newbie
Currently Being Moderated
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 11.2.0.2 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) :

--type
-- this works, creates the type
CREATE OR REPLACE TYPE [schema].prod_type AS OBJECT (
pid INT,
pprice NUMBER,
MEMBER PROCEDURE display(pid IN NUMBER))
NOT INSTANTIABLE NOT FINAL;

-- subtype
-- this doesn't work, it creates the type "deal_type" separately

CREATE OR REPLACE TYPE [schema].deal_type UNDER prod_type (
ctr NUMBER
);

I've tried adding the schema name after UNDER, e.g. UNDER [schema].prod_type with the same result.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points