create or replace function get_take_item_activity (in_gift_id in number)
--注意, oracle函数不能子啊 return之前 is , 或者定义变量
RETURN item_activity_type PIPELINED
is
cursor return_list is select iir.* from item_itcat_r iir where iir.gift_id = in_gift_id;
var_abc number:=1;
begin
for list in return_list loop
pipe row(item_activity_obj (list.status,‘1‘,sysdate,sysdate,list.status,list.status,list.status,list.status,‘1‘,‘1‘,list.status));
end loop;
return;
end get_take_item_activity;