PL/SQL (MOSC)

MOSC Banner

pipeline function

edited Apr 19, 2011 10:59PM in PL/SQL (MOSC) 4 commentsAnswered
 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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center