Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-00932 and Select * from <table>, using nested table.

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US