Stored Procedures - passing arrays as parameters

[Des McHugh]

I am accessing an Oracle8 database using Oracle Objects from a VC++ application.
Can anyone tell me how to write the stored procedure so that it will accept OParamArrays as parameters

The procedure is currently :


CREATE OR REPLACE PROCEDURE UpdateCurrencies (SwiftCode IN VARCHAR2, Name IN VARCHAR2, EuroFactor IN NUMBER, EuroDate IN NUMBER, Act IN CHAR)

AS

BEGIN

if Act = 'A' then
insert into CURR (Curr_SwiftCode, Curr_Name, Curr_EuroFactor, Curr_EuroDate) values (SwiftCode, Name, EuroFactor, EuroDate);
elsif Act = 'M' then
update CURR set Curr_Name = Name, Curr_EuroFactor = EuroFactor, Curr_EuroDate = EuroDate where Curr_SwiftCode = SwiftCode;
elsif Act = 'D' then
delete from CURR where Curr_SwiftCode = SwiftCode;
end if;

END;
/




but I want to pass in Arrays rather than single parameters.

thanks,
Des.