pipeline function
Hi,
I have created this package and execute it :
create or replace package test
as
type t_no_adher is table of adherent.no_adher%type;
function retour (p_no_adher in out nocopy t_no_adher ) return t_no_adher pipelined;
end;
/
create or replace package body test
as
function retour (p_no_adher in out nocopy t_no_adher ) return t_no_adher pipelined
is
begin
for i in 1..p_no_adher.count() loop
pipe row (p_no_adher(i));
end loop;
end;
end;
/
show errors
set serveroutput on
declare
v_no_adher test.t_no_adher;
type t_nom is table of adherent.nom%type index by binary_integer;
I have created this package and execute it :
create or replace package test
as
type t_no_adher is table of adherent.no_adher%type;
function retour (p_no_adher in out nocopy t_no_adher ) return t_no_adher pipelined;
end;
/
create or replace package body test
as
function retour (p_no_adher in out nocopy t_no_adher ) return t_no_adher pipelined
is
begin
for i in 1..p_no_adher.count() loop
pipe row (p_no_adher(i));
end loop;
end;
end;
/
show errors
set serveroutput on
declare
v_no_adher test.t_no_adher;
type t_nom is table of adherent.nom%type index by binary_integer;
0