错误报告- ORA-02330:数据类型规范不允许.00000 -创建对象关系表时

Question

我试图创建两个对象关系表，并希望在部门表中创建一个外键来引用员工表的主键。它抛出"ORA-02330:数据类型规范不允许";当我尝试创建DEPARTMENT TABLE时当我尝试创建DEPARTMENT TABLE时

CREATE or Replace TYPE EMP_TYPE AS OBJECT
(
EMP_ID INTEGER,
EMP_FNAME VARCHAR2(20),
EMP_LNAME VARCHAR2(25),
ADDRESS VARCHAR(30),
SALARY   NUMBER (10),
JOB_TITLE   VARCHAR2 (20));
CREATE TABLE EMPLOYEE OF EMP_TYPE (EMP_ID PRIMARY KEY);

---

CREATE OR REPLACE TYPE DEPT_TYPE AS OBJECT(
DEPT_ID INTEGER,
EMP_ID INTEGER,
DEPT_NAME VARCHAR(20),
LOCATION VARCHAR(20));
CREATE TABLE DEPARTMENT OF DEPT_TYPE (EMP_ID FOREIGN KEY REFERENCES EMPLOYEE(EMP_ID)) 

最后一行抛出错误

Answer 1

错误的语法。应该是

SQL> CREATE OR REPLACE TYPE EMP_TYPE AS OBJECT
2  (
3     EMP_ID INTEGER,
4     EMP_FNAME VARCHAR2 (20),
5     EMP_LNAME VARCHAR2 (25),
6     ADDRESS VARCHAR (30),
7     SALARY NUMBER (10),
8     JOB_TITLE VARCHAR2 (20)
9  );
10  /
Type created.
SQL> CREATE TABLE EMPLOYEE OF EMP_TYPE
2  ( EMP_ID PRIMARY KEY );
Table created.

---

SQL> CREATE OR REPLACE TYPE DEPT_TYPE AS OBJECT
2  (
3     DEPT_ID INTEGER,
4     EMP_ID INTEGER,
5     DEPT_NAME VARCHAR (20),
6     LOCATION VARCHAR (20)
7  );
8  /
Type created.
SQL> CREATE TABLE DEPARTMENT OF DEPT_TYPE
2  ( EMP_ID REFERENCES EMPLOYEE (EMP_ID) );
Table created.
SQL>