c# - 将输入字段与数据库中的值进行比较时出错

Question

尝试将我从输入字段中获得的值与使用 mysql 的数据库中的值进行比较，但出现错误:Oracle.DataAccess.Client.OracleException: 'ORA-00911: invalid character'

OracleCommand cmd2 = new OracleCommand();
            cmd2.Connection = conn;
            cmd2.CommandText = "SELECT Name FROM Actors WHERE EXISTS (SELECT * FROM Actors WHERE Name = Omar ); ";
            cmd2.Parameters.Add("name", textBox7.Text);
            cmd2.CommandType = CommandType.Text;
            reader = cmd2.ExecuteReader();
            while (reader.Read())
            {
                if(reader[0].Equals(1))
                {
                    while (reader.Read())
                    {
                        {
                            ID_VALUE = Convert.ToInt32(reader["ID"]);
                        }
                    }
                    cmd2.CommandText = $"insert into Movies_Actors values(:ID,{ID_VALUE})";
                    cmd2.Parameters.Add("ID", textBox1.Text);
                    cmd2.ExecuteNonQuery();
                }
                else
                {
                    doesnotExist = true;
                }
            }

标签： c#odb