17,086
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE T179
(
ID VARCHAR(2),
NAME VARCHAR(10)
);
INSERT INTO T179 VALUES('01', 'AA');
INSERT INTO T179 VALUES('02', 'BB');
create or replace type TYP_OBJ as object
(
id varchar(2),
name varchar(10)
);
create or replace type TYP_LIST AS TABLE OF TYP_OBJ;
COMMIT;
CREATE OR REPLACE PROCEDURE prc_test(prm_2 OUT TYP_LIST)
IS
BEGIN
SELECT typ_obj(ID, NAME) BULK COLLECT INTO prm_2 FROM T179;
END prc_test;