Код: Выделить всё
-- Заголовок пакета
type r_test is record (
item1 varchar2(100),
item2 number,
item3 date
);
type a_test is table of r_test;
function test_piplenined (
p_d_beg date default null,
p_d_end date default null
)
return a_test parallel_enable pipelined;
-- Тело пакета
function test_piplenined (
p_d_beg date default null,
p_d_end date default null
)
return a_test parallel_enable pipelined
is
result_row r_test;
begin
result_row.item1 := 'p_d_beg='||to_char(p_d_beg, 'yyyy-dd-mm')||'; p_d_end='||to_char(p_d_end, 'yyyy-dd-mm');
result_row.item2 := 1;
result_row.item3 := sysdate;
pipe row(result_row);
result_row.item2 := 2;
result_row.item3 := sysdate;
pipe row(result_row);
result_row.item2 := 3;
result_row.item3 := sysdate;
pipe row(result_row);
end;
ОС: Windows 7 64x (VirtualBox)
Application: dbForge Studio for Oracle
Product: Devart dbForge Studio for Oracle
Product Edition: Русская редакция
Product Locale: Russian
Assembly: dbforgeoracle, Version=3.7.472.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.exe
Global cache: False
Framework: 4.0.30319.1