Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!noris.net!news2.arglkargh.de!news.mixmin.net!out01a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!p47g2000hsd.googlegroups.com!not-for-mail
From:  "lucascarvalho@gmail.com" <lucascarvalho@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: ORA-00932 and Select * from <table>, using nested table.
Date: Mon, 11 Jun 2007 19:16:46 -0000
Organization: http://groups.google.com
Lines: 38
Message-ID: <1181589406.152996.207160@p47g2000hsd.googlegroups.com>
NNTP-Posting-Host: 200.167.129.18
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1181589406 22658 127.0.0.1 (11 Jun 2007 19:16:46 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 11 Jun 2007 19:16:46 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.4) Gecko/20061201 Firefox/2.0.0.4 (Ubuntu-feisty),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 beta.cefetcampos.br:3128 (squid/2.5.STABLE12-20051114)
Complaints-To: groups-abuse@google.com
Injection-Info: p47g2000hsd.googlegroups.com; posting-host=200.167.129.18;
   posting-account=HyvT4g0AAAA9md0Jg12TUszMGD9-M0cy
Xref: news.f.de.plusline.net comp.databases.oracle.server:199138

  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>