ORA-00932 and Select * from <table>, using nested table.

From: <lucascarvalho_at_gmail.com>
Date: Mon, 11 Jun 2007 19:16:46 -0000
Message-ID: <1181589406.152996.207160@p47g2000hsd.googlegroups.com>

  I am using oracle-xe-univ-10.2.0.1-1.0.i386.rpm and I have this simple example.

CREATE TYPE Course AS OBJECT (

    course_no NUMBER(4),
    title VARCHAR2(35),
    credits NUMBER(1));

 CREATE TYPE CourseList AS TABLE OF Course;

 CREATE TABLE department (

    name     VARCHAR2(20),
    director VARCHAR2(20),
    office   VARCHAR2(20),

    courses CourseList)
    NESTED TABLE courses STORE AS courses_tab;

   INSERT INTO department

      VALUES('Psychology', 'Irene Friedman', 'Fulton Hall 133',
         CourseList(Course(1000, 'General Psychology', 5),
                    Course(2100, 'Experimental Psychology', 4),
                    Course(2200, 'Psychological Tests', 3),
                    Course(2250, 'Behavior Modification', 4),
                    Course(3540, 'Groups and Organizations', 3),
                    Course(3552, 'Human Factors in Busines', 4),
                    Course(4210, 'Theories of Learning', 4),
                    Course(4320, 'Cognitive Processes', 4),
                    Course(4410, 'Abnormal Psychology', 4)));

The problem is when I try to execute:

SELECT * FROM department;

I am gotting this error:

ORA-00932: inconsistent datatypes: expected NUMBER got ARGUS.COURSELIST; <Btw Argus is my database name> Received on Mon Jun 11 2007 - 14:16:46 CDT