Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Sending from ASP page arrays to an Oracle Stored Procedure


Message #1 by "Smitha" <smithachandy@y...> on Wed, 16 Oct 2002 13:05:08
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

  Return to Index