Question

当我执行C#script,如灯塔时,请ORA-01036:非法变更姓名/编号

using (OracleConnection conn = new OracleConnection(connectionString))
using (OracleCommand cmd = conn.CreateCommand())
using (OracleDataAdapter da = new OracleDataAdapter())
using (DataTable dt = new DataTable())
{
  cmd.BindByName = true;   
  cmd.CommandText = "SELECT :A A FROM DUAL";
  cmd.Parameters.Add("A", "THE DATA");
  da.SelectCommand = cmd;    
  da.Fill(dt);
}

but when I change cmd.CommandText = "SELECT :A A FROM DUAL"; to cmd.CommandText = "SELECT A A FROM DUAL where :A = THE DATA "; it s run

我的问题是:bind params between select and from,t bebro by C#?

SOLUTION : I ve changed the library from Oracle.DataAccess to Oracle.ManagedDataAccess

Answer 1

我更换了Oracle。向Oracle提供数据图书馆

Answer 2

无效特性为:,因为在选定发言中不能予以承认,因此其行文如下:

cmd.CommandText = "SELECT A FROM DUAL WHERE A = @A";
cmd.Parameters.Add("@A", "THE DATA");

甲型六氯环己烷 A from

为了回答你的问题,错误来自Kall query,而不是C#。

友情链接