enterprise library 执行oracle语句？

[web_gus]

enterprise library 执行oracle语句时的其中的参数不是用@么？
public bool Exists(string AAA100)
{
Database db = DatabaseFactory.CreateDatabase();
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from UA10 where AAA100=@AAA100 ");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "AAA100", DbType.String, AAA100);
int cmdresult;
object obj = db.ExecuteScalar(dbCommand);
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = int.Parse(obj.ToString());
}
if (cmdresult == 0)
{
return false;
}
else
{
return true;
}
}

Error:ORA-01036 非法的变量名/编号?

ps:clob字段怎么设置对应的dbtype？

[web_gus]

up一下，项目急用

[soaringbird]

试试这样：
db.AddInParameter(dbCommand, "@AAA100", DbType.String, AAA100);

[web_gus]

这个也不行，我试了一下
strSql.Append("select count(1) from UA10 where AAA100=:AAA100 ");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "AAA100", DbType.String, AAA100);
这样不出ORA-01036 非法的变量名/编号错误，变成tns写入失败。

[vosov]

oracle参数应该用“:”，而不是“@”