Re: Passing arrays as parameters [message #369754] |
Wed, 04 October 2000 08:22 |
Suresh
Messages: 189 Registered: December 1998
|
Senior Member |
|
|
Hi graham,
You can pass pl/sql tables as parameters to procedures. but you need to declare that table type in package or you have to create that type.
because that table type should be global to called procedure also.
E.g: (if you r using oracle 7)
create or replace package p1 as
TYPE arr_sqlerree_type IS TABLE OF sqlerree%ROWTYPE
INDEX BY BINARY_INTEGER;
end;
create or replace procedure pr1(param1 p1.sqlerree) as
begin
--statements
end;
calling pr1 procedure from other procedure
create or replace procedure pr2 as
lArray p1.sqlerree;
begin
--build lArray and pass to pr1
pr1(lArray);
end;
Hope this helps
Suresh
|
|
|