How to pass an array type parameter and normal parameter into a procedure in pl/sql ?

As mentioned in above answer you need to use Microsoft SQL Server 2008 or higher.

Then you can use table-valued parameters to pass the multiple data values through a single parameter.

Here is an example.

Step 1: you need to create the table-valued parameter type as you need.

CREATE TYPE dbo.Products AS TABLE
    ( ID int, Description varchar(50) )

Step 2: Then create a Stored Prcedure

CREATE PROCEDURE getProductDetails 
    (@itemIDs dbo.Products)
AS
BEGIN

SELECT * FROM @Products

END

Step 3: In order to pass the data from c# or what ever the code, create a DataTable object and pass it to the Stored Procedure as we pass to the normal parameters.