Arrays and functions [message #37214] |
Thu, 24 January 2002 13:11 |
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 |
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'))
|
|
|