C# OracleParameter 使用问题

[ayumilove]

                        StringBuilder strSql = new StringBuilder();

                        strSql.Append("insert   into   Order_Main( ");
                                                strSql.Append("ORG_ID,UUID,CODE,SPEC_LIST_ID,BRAND_LIST_ID,XJFJ_LIST_ID,BARCODE,S_LOCATION_ID,D_LOCATION_ID,ADRESS,CONTACT1,PHONE1) ");
                        strSql.Append("   values   ( ");
                        strSql.Append(":orguuid,:mainuuid,:code,:appoint_date,:spec_list_id,:brand_list_id,:xjfj_list_id,:barcode,:s_location_id,:d_location_id,:adress,:contact1,:phone1) ");

                        OracleParameter[] parameters =   {
                        new   OracleParameter( ":orguuid ",OracleType.Number,4),
                        new   OracleParameter( ":mainuuid ",   OracleType.Number,16),
                        new   OracleParameter( ":code ",   OracleType.NVarChar,100),
                        //new   OracleParameter( ":appoint_date ",   OracleType.DateTime),
                        new   OracleParameter( ":spec_list_id ",   OracleType.Number,16),
                        new   OracleParameter( ":brand_list_id ",   OracleType.Number,16),
                        new   OracleParameter( ":xjfj_list_id ",   OracleType.Number,16),
                        new   OracleParameter( ":barcode ",   OracleType.NVarChar,100),
                        new   OracleParameter( ":s_location_id ",   OracleType.NVarChar,100),
                        new   OracleParameter( ":d_location_id ",   OracleType.NVarChar,100),
                        new   OracleParameter( ":adress ",   OracleType.NVarChar,1000),
                        new   OracleParameter( ":contact1 ",   OracleType.NVarChar,100),
                        new   OracleParameter( ":phone1 ",   OracleType.NVarChar,100)};

                        parameters[0].Value = dt.Rows[i]["orguuid"];
                        parameters[1].Value = dt.Rows[i]["mainuuid"];
                        parameters[2].Value = dt.Rows[i]["code"];
                        //parameters[3].Value = dt.Rows[i]["appoint_date"];
                        parameters[3].Value = dt.Rows[i]["spec_list_id"];
                        parameters[4].Value = dt.Rows[i]["brand_list_id"];
                        parameters[5].Value = dt.Rows[i]["xjfj_list_id"];
                        parameters[6].Value = dt.Rows[i]["barcode"];
                        parameters[7].Value = dt.Rows[i]["s_location_id"];
                        parameters[8].Value = dt.Rows[i]["d_location_id"];
                        parameters[9].Value = dt.Rows[i]["adress"];
                        parameters[10].Value = dt.Rows[i]["contact1"];
                        parameters[11].Value = dt.Rows[i]["phone1"];
                        OracleHelper.ExecuteNonQuery(oradb, CommandType.Text, strSql.ToString(), parameters);

OracleHelper 是 从网上下载的
OracleHelper based on Microsoft Data Access Application Block (DAAB) for .NET
看 ExecuteNonQuery 好像支持这种用法

		/// <summary>
		/// Execute an OracleCommand (that returns no resultset) against the specified OracleConnection 
		/// using the provided parameters.
		/// </summary>
		/// <remarks>
		/// e.g.:  
		///  int result = ExecuteNonQuery(conn, CommandType.StoredProcedure, "PublishOrders", new OracleParameter("@prodid", 24));
		/// </remarks>
		/// <param name="connection">a valid OracleConnection</param>
		/// <param name="commandType">the CommandType (stored procedure, text, etc.)</param>
		/// <param name="commandText">the stored procedure name or PL/SQL command</param>  
		/// <param name="commandParameters">an array of OracleParameters used to execute the command</param>
		/// <returns>an int representing the number of rows affected by the command</returns>
		public static int ExecuteNonQuery(OracleConnection connection, CommandType commandType, string commandText, params OracleParameter[] commandParameters)
		{	
			//create a command and prepare it for execution
			OracleCommand cmd = new OracleCommand();
			PrepareCommand(cmd, connection, (OracleTransaction)null, commandType, commandText, commandParameters);
			
			//finally, execute the command.
			return cmd.ExecuteNonQuery();
		}

运行代码时 提示 非法的变量名/编号

该怎么处理这个问题呢？

多谢指教

[ayumilove]

这个上面的 是SQL 的用例
http://blog.sina.com.cn/s/blog_60cd40150101021k.html

[kingtami]

看起来可能就是:要改成@

[ayumilove]

@ 我也试过了 不行啊

[ayumilove]

我知道问题所在了，
只能说Oracle 太XXXXXXX了
变量名 内的 空格敏感

[anzhiqiang_touzi]

[Quote=引用 4 楼 的回复:]
我知道问题所在了，
只能说Oracle 太XXXXXXX了
变量名 内的 空格敏感
[/Quote]