_cmdGetCustomerControlIds = CreateEmptyTextCommand();

                var commandText = new StringBuilder();
                commandText.Append(@"SELECT CONTROLID, CONTROLDATA FROM TBCONTROL WHERE COMPANYID = :P_COMPANYID AND STORELOCID = :P_STORELOCID
                                                              AND CONTROLID IN (");
                for (int i = 0; i < controlIdsToBeLoaded.Count; i++)
                {
                    commandText.Append(":P_CONTROLID");
                    commandText.Append(i);
                    if (i < controlIdsToBeLoaded.Count - 1)
                        commandText.Append(", ");

                    if (i == controlIdsToBeLoaded.Count - 1)
                        commandText.Append(")");

                    _cmdGetCustomerControlIds.Parameters.Add("P_CONTROLID" + i, OracleDbType.Varchar2);
                }

                _cmdGetCustomerControlIds.CommandText = commandText.ToString();
                _cmdGetCustomerControlIds.Parameters.Add("P_COMPANYID", OracleDbType.Int32);
                _cmdGetCustomerControlIds.Parameters.Add("P_STORELOCID", OracleDbType.Int32);
                _cmdGetCustomerControlIds.Prepare();