Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing an array to an Oracle stored procedure

811996Nov 9 2010 — edited Nov 10 2010
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2010
Added on Nov 9 2010
7 comments
10,491 views