Hi
I am using oracle 9.2.0.1 in windows XP.
When I try to alter a co-dependent type I get an error as follows.
Please look at the script and help me to solve it.
Thanks
CREATE TYPE Dept_ty
/
CREATE TYPE Emp_ty AS OBJECT(
eno NUMBER(4),
dob date,
edept REF dept_ty
)
/
CREATE TYPE Dept_ty AS OBJECT(
dno NUMBER(2),
mgr REF Emp_ty
)
/
ALTER TYPE Emp_ty
ADD MEMBER FUNCTION age RETURN NUMBER CASCADE
/
ALTER TYPE Emp_ty
*
ERROR at line 1:
ORA-22324: altered type has compilation errors
ORA-00600: internal error code, arguments: [4883], [0x677A6010], [0x659CABD4],
[], [], [], [], []