Passing an array

 

Hello,

I need to pass an array to the query.  I have a code related it. But It shows me only first row when I execute it . And when I see from the 10046 trace file there is only one value. It was the first element of array that I created below. Does anyone  have any idea using properly please help me? Thank you

    String[] groupArray = { "BAT", "BATG", "BATE", "BATR" };
    String[] tableArray = { "BAT1", "BAT2", "BAT3", "BAT4" };

    cmd = new OracleCommand("SELECT TABLE_ID, GROUP_ID, DESC FROM TABLES WHERE GROUP_ID = :WGROUP_ID AND TABLE_ID = :WTABLE_ID", conn);

    cmd.CommandType = CommandType.Text;