Urgent : record set in Stored procedure output parameter

[anili98]

I need to call a oracle stored procedure in ASP. The Stored procedure will perform some business rules and returns array / record set in the out parameter.

Can some one please suggest me a way to capture the the array of records returned by the stored procedure in ASP?

Following is the code I used to execute the procedure from SQL PLUS.

declare
arr3 generic_procs.arr1;
begin
generic_procs.national_avg(arr3);
for i in 1..10 loop
dbms_output.put_line(arr3(i).a||'='||arr3(i).b);
end loop;
end;