Problem REF
984152Feb 14 2013 — edited Feb 14 2013hi
CREATE TYPE emp_person_typ AS OBJECT (
name VARCHAR2(30),
manager REF emp_person_typ );
CREATE TABLE emp_person_obj_table OF emp_person_typ;
INSERT INTO emp_person_obj_table VALUES (
emp_person_typ ('John Smith', NULL));
SELECT *
FROM emp_person_obj_table;
in APPEX I get the following error:
ORA-00932: inconsistent datatypes: expected NUMBER got REF db.emp_person_typ
I was told that APPEX not accept REF, I wanted to know how I could do
Edited by: 981149 on 14-feb-2013 8.02