How to assign a list of integers as the parameter value for an oracle command parameter in the where clause ?

See more:

C#

.NET

Oracle

ODP.NET

I have a query like
Select * from tablename where id in (:ids);

I want to assign a list of integers for the above parameter :ids.
I am using the ODP.Net with C#.

The code snippet will be something like this

const String sql = Select * from tablename where id in (:ids);

using(OracleCommand cmd = new OracleCommand(sql, dbc)) {
cmd.Parameters.Add(:ids, OracleDbType.Int64, 12, Ids , ParameterDirection.Input);
using(OracleDataReader rdr = cmd.ExecuteReader()) {
}
}

But its throwing some errors...

Can anybody please help on this ?