Dear johram,

I do practice to generate unknow size of parameter in runtime. Below is part of the code:

sql = "UPDATE CONSUMER SET STATUS=:STA WHERE ";


foreach (string acc in accountList) {
	sqlaccountlist = sqlaccountlist + ":ACCNUM" + count.ToString + ", ";
	count = count + 1;
}


if (count > 1) {
	sqlaccountlist = Left(sqlaccountlist, sqlaccountlist.Length - 2);
	sqlaccountlist = " ACCNUM IN (" + sqlaccountlist + ") ";
	sql = sql + sqlaccountlist;
}


.
.
.
.
.


for (i = 1; i <= count; i++) {
	MyDBCommand.Parameters.Add("ACCNUM" + i.ToString, OracleDbType.Varchar2).Value = accountList(i - 1);
}