CREATE OR REPLACE TYPE MY_TYPE as object(code VARCHAR2(18), p_name VARCHAR2(16))CREATE OR REPLACE TYPE CourseList AS TABLE OF MY_TYPEcreate table DEPARTMENT
(
NAME VARCHAR2(20),
DIRECTOR VARCHAR2(20),
OFFICE VARCHAR2(20),
COURSES COURSELIST
)nested table COURSES store as COURSES_TABLE;declare
mycursor sys_refcursor;
vprojects projectlist;
begin
open mycursor for select courses from department;
fetch mycursor BULK COLLECT INTO vprojects;
close mycursor;
end;报错是什么原因呢?
declare
vprojects courselist;
begin
select courses into vprojects from department;
end;这样可以
应该是
vprojects courselist;
declare
mycursor sys_refcursor;
vprojects courselist;
begin
open mycursor for select courses from department;
fetch mycursor BULK COLLECT INTO vprojects;
close mycursor;
end;应该是这样
上边的写错了不好意思
CREATE OR REPLACE TYPE MY_TYPE as object(code VARCHAR2(18), p_name VARCHAR2(16))CREATE OR REPLACE TYPE CourseList AS TABLE OF MY_TYPEcreate table DEPARTMENT
(
NAME VARCHAR2(20),
DIRECTOR VARCHAR2(20),
OFFICE VARCHAR2(20),
COURSES COURSELIST
)nested table COURSES store as COURSES_TABLE;declare
mycursor sys_refcursor;
vprojects courselist;
begin
open mycursor for select courses from department;
fetch mycursor BULK COLLECT INTO vprojects;
close mycursor;
end;为什么出错呢
mycursor sys_refcursor;
type CourseListType is table of DEPARTMENT.Courses%type;
vprojects CourseListType;
begin
open mycursor for select courses from department;
fetch mycursor BULK COLLECT INTO vprojects;
close mycursor;
end;
这样试试