Passing an array to an Oracle stored procedure
811996Nov 9 2010 — edited Nov 10 2010I am new to Oracle and I am having problems passing an array to an oracle stored procedure. I need to pass an id array of strings and delete all rows matching the ID array. Right now I am able to delete a single row with this procedure.
CREATE OR REPLACE PROCEDURE DBOLTP.TESTPROCEDURE2
+(SeekrID varchar2) AS+
BEGIN
delete from job_searches where seeker_id = SeekrID;
END;
How would I modify this procedure to accomodate an array?
Thanks in advance