Create oracle SP which will pass many values to the same parameter

I need to write oracle stored procedure which will pass many values to the same parameter. In that stored procedure will be 3 or 4 parameters with many values. Something like: Create or replace procedure InsertTopper (AOD IN NUMBER, AOD1 in NUMBER, AOD2 in NUMBER AODout out NUMBER District in VARCHAR2, District1 in VARCHAR2, District3 in VARCHAR2 DistrictOUT out VARCHAR2) IS Begin SELECT * FROM table where DATE = TO_DATE('08/05/2015','mm/dd/yyyy') and AOD ;= AOD and District ;=District and copies > 0; Please help Thanks