CREATE OR REPLACE TYPE emp_type AS OBJECT
(empno NUMBER(4); ename VARCHAR2(10);
job VARCHAR2(9);
mgr NUMBER(4);
hiredate DATE;
sal NUMBER(7,2);
comm NUMBER(7,2)
);
在plsql的sql windows窗口下,执行报如下错误:
Compilation errors for TYPE SCOTT.EMP_TYPEError: PLS-00103: Encountered the symbol "" when expecting one of the following:
( not external JAVA_ BOUND_
Line: 2
Text: (empno NUMBER(4);这个如何弄呢?
(empno NUMBER(4); ename VARCHAR2(10);
job VARCHAR2(9);
mgr NUMBER(4);
hiredate DATE;
sal NUMBER(7,2);
comm NUMBER(7,2)
);
在plsql的sql windows窗口下,执行报如下错误:
Compilation errors for TYPE SCOTT.EMP_TYPEError: PLS-00103: Encountered the symbol "" when expecting one of the following:
( not external JAVA_ BOUND_
Line: 2
Text: (empno NUMBER(4);这个如何弄呢?
(empno NUMBER(4),
ename VARCHAR2(10),
job VARCHAR2(9),
mgr NUMBER(4),
hiredate DATE,
sal NUMBER(7,2),
comm NUMBER(7,2)
);
(empno NUMBER(4),
ename VARCHAR2(10),
job VARCHAR2(9),
mgr NUMBER(4),
hiredate DATE,
sal NUMBER(7,2),
comm NUMBER(7,2)
);
--楼主的空格有问题
CREATE OR REPLACE type emp_type as object(
empno NUMBER(4),
ename VARCHAR2(10),
job VARCHAR2(9),
mgr NUMBER(4),
hiredate DATE,
sal NUMBER(7,2),
comm NUMBER(7,2)
);
/
empno NUMBER(4),
ename VARCHAR2(10),
job VARCHAR2(9),
mgr NUMBER(4),
hiredate DATE,
sal NUMBER(7,2),
comm NUMBER(7,2)
);
/
字段之间应该为逗号,不是分号
up[/Quote]