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) ;

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

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