Parameters of entry in Stored Procedure with more than one value

0

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.

    
asked by anonymous 11.01.2018 / 12:44

0 answers