oracle--type类型初始化

create or replace type marktype is object
(

studentName   varchar2(50),

chineseMark    number,

mathMark        number,

englishMark    number,

remark             varchar2(100)

    );

create or replace type  markTable AS table OF marktype;

测试：

  declare
  -- Non-scalar parameters require additional processing 
  courseAll     markTable  :=   markTable();
begin
courseAll.extend;
courseAll(1) := marktype('小明',85,90,100,' ');

(要传入多条数据可以用courseAll.extend加上courseAll(i))

computeSumMark(courseAll=>courseAll,

                                   sumMark=>sumMark

                                );

end;