Home » SQL & PL/SQL » SQL & PL/SQL » Arrays and functions
Arrays and functions [message #37214] Thu, 24 January 2002 13:11 Go to next message
Jamie Mack
Messages: 8
Registered: January 2002
Junior Member
Hey i want to pass an array out of a function (for the use of creating a quite complex view) is this possible? I have played around with it for a while but cant figure it out. Anyone tried it before?

Cheers Jamie
Re: Arrays and functions [message #37220 is a reply to message #37214] Fri, 25 January 2002 00:30 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
look if it is helpful for you .

create or replace package pack as
type array is table of number(10);
procedure pro1(a array) ;
end;

create or replace package body pack as
procedure pro1(a array) as
begin
for i in 1..a.count loop
dbms_output.put_line(a(i));
end loop;
end;
end;

exec pack.pro1(pack.array('1','2'))
Previous Topic: Fetch into array
Next Topic: using procedure
Goto Forum:
  


Current Time: Tue Aug 11 23:25:24 CDT 2020