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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 11 Jun 2007 21:20:17 +0200
Message-ID: <466da073$0$17779$426a74cc@news.free.fr>

<lucascarvalho_at_gmail.com> a écrit dans le message de news: 1181589406.152996.207160_at_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>
|

Works for me in 10.2.0.3:
SQL> SELECT * FROM department;

NAME                 DIRECTOR             OFFICE
-------------------- -------------------- --------------------

COURSES(COURSE_NO, TITLE, CREDITS)

---

Psychology Irene Friedman Fulton Hall 133 COURSELIST(COURSE(1000, 'General Psychology', 5), COURSE(2100, 'Experimental Psychology', 4), COURSE(2200, 'Psychologica l 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))

Regards
Michel Cadot Received on Mon Jun 11 2007 - 14:20:17 CDT