1 2 Previous Next 25 Replies Latest reply on Feb 14, 2013 7:36 PM by TexasApexDeveloper

    Problem REF


      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
        1 2 Previous Next