在包中创建函数返回一个表,包无法生成有问题?
create or replace package pkg_test
as
type obj is object(a varchar2(20));
type objtabe is table of obj; //提示这句问题
function get(s varchar2) return objtabe ;
end pkg_test;
create or replace package body pkg_test
as
function get(s varchar2) return objtabe
is
t objtabe;
begin
t:= objtabe();
t.extend;
t(1):= obj(‘B’);
return t;
end get;
end pkg_test;