I need to do a stored procedure in oracle where I have 5 input parameters and 1 output parameter that will be a cursor (recordset). The problem is that each input parameter can receive more than one value, that is, a list of values. These received parameters will be used as filters in my WHERE clause.
For example, one of the input parameters will be p_customerID and this parameter may receive "ID001, ID002, ID003 ..." and in the return cursor select I should filter these IDs:
WHERE CUSTOMER in p_customerID
My questions:
-
How can I use this parameter in WHERE to filter the values passed as parameters.
obs: This procedure will be called by an external system and given the cursor (recordset / refcursor) as a return.