c# – 错误在我的SQL语句中说“缺少右括号”……但事实并非如此

(由gbn编辑,格式清晰,所以不是全部在一行)

DbCommand.CommandText =
             @"SELECT 
      HIST.MBRSEP,HIST.LOCATION,HIST.BILLTYPE,HIST.BILLMOYR,LOCINFO.CYCLE,LOCINFO.DIST,LOCINFO.LOCATION
    FROM 
      (CAV_MBRHISTDEL AS HIST INNER JOIN CAV_LOCINFODETL AS LOCINFO ON HIST.LOCATION = LOCINFO.LOCATION)
    WHERE
       LOCINFO.CYCLE = @CYCLE AND 
       LOCINFO.DIST = @DISTRICT AND 
       HIST.BILLTYPE = '09' AND 
       HIST.BILLMOYR <> '9999'";

这是错误消息：

ERROR [HY000] [Oracle][ODBC][Ora]ORA-00907: missing right parenthesis

我的SQL语句中只有两个括号,一个是右边的,一个是左边的.我不确定错误告诉我的是什么.有什么建议？

编辑：以下是如何定义参数：

string cycle = cbCycle.Text;
        string district = cbDistrict.Text.Substring(0,2);

这是我将它们添加到DbCommand的地方：

DbCommand.Parameters.AddWithValue("@CYCLE",cycle);
        DbCommand.Parameters.AddWithValue("@DISTRICT",district);

这是我的完整代码,当有人点击我的表单上的“转到”按钮时触发：

private void btnGo_Click(object sender,EventArgs e)
    {
        //get parameters
        string cycle = cbCycle.Text;
        string district = cbDistrict.Text.Substring(0,2);

        //create a connection to the database
        OdbcConnection DbConnection = new OdbcConnection("DSN=UPN2;uid=xxx;pwd=xxxx");
        DbConnection.Open();

        //create a command to extract the required data and
        //assign it to the connection string
        OdbcCommand DbCommand = DbConnection.CreateCommand();
        DbCommand.CommandText =
             @"SELECT HIST.MBRSEP,LOCINFO.LOCATION FROM CAV_MBRHISTDEL AS HIST INNER JOIN CAV_LOCINFODETL AS LOCINFO ON HIST.LOCATION = LOCINFO.LOCATION WHERE LOCINFO.CYCLE = @CYCLE AND LOCINFO.DIST = @DISTRICT AND HIST.BILLTYPE = '09' AND HIST.BILLMOYR <> '9999'; ";

        DbCommand.Parameters.AddWithValue("@CYCLE",district);

        //Create a DataAdapter to run the command and fill the datatable
        OdbcDataAdapter da = new OdbcDataAdapter();
        da.SelectCommand = DbCommand;
        DataTable dt = new DataTable();
        da.Fill(dt);


        tbOutput.Text = PrintDataTable(dt);

        DbCommand.Dispose();
        DbConnection.Close();

    }