I have a backend package in which i have a defined public Type(which acts
as an array),
The procedures in the package use these types as input parameters.
I need to pass from an ASP page, arrays back to the procedure.
For example my package is as follows
create or replace package packTest is
-- Public type declarations
type tblInput1 is Table of Varchar2(1000) INDEX BY BINARY_INTEGER;
type tblInput2 is Table of Varchar2(2000) INDEX BY BINARY_INTEGER;
-- Public function and procedure declarations
procedure test1(itblInput1 in tblBody, itblInput2 in tblRemark, oStatus
out varchar2);
end packTest;
create or replace package body packTest is
procedure test1(abody in tblBody, btblRemark in tblRemark, oStatus out
varchar2)
is
i binary_integer;
begin
for i in 1..abody.count
loop
dbms_output.put_line(abody(i));
dbms_output.put_line(btblremark(i));
end loop;
oStatus := 'OK';
end test1 ;
end packTest;
From the asp page, how do I create the input arrays and how do I pass them
back to the backend using the CreateParameter. Do i use adArrays as the
variable?
How do I do this?
Any help on this would be great!
Thanks
Smitha