create or replace package B_Tools is
type T_TEST_row is record
(
id varchar2(60),
name varchar2(60)
);
type T_TEST is table of T_TEST_row;
end B_Tools;
--比如:
procedure TEST
IS
T_集合 T_TEST;
T_单行 T_TEST_row;
BEGIN
--多行,注意使用 Bulk Collect
select id,name Bulk Collect into T_集合 from testtable;
--单行,注意结果只能一行数据
select id,name into T_单行 from testtable;
END;