oracle强制更新type,无法将类型为'Oracle.ManagedDataAccess.Types.OracleDecimal []'的对象强制转换为'System.IConvertible'(...

最新推荐文章于 2023-04-11 17:25:53 发布

weixin_39945789

最新推荐文章于 2023-04-11 17:25:53 发布

阅读量1k

点赞数

文章标签： oracle强制更新type

无法将类型为'Oracle.ManagedDataAccess.Types.OracleDecimal []'的对象强制转换为'System.IConvertible'(Unable to cast object of type 'Oracle.ManagedDataAccess.Types.OracleDecimal[]' to type 'System.IConvertible')

我不知道如何解决这个错误。

我上课了

public class MyClass

{

public OracleDecimal ID { get; set; }

public string FIELD1 { get; set; }

public string FIELD2 { get; set; }

public OracleDate FIELD3 { get; set; }

}

我建立了一个List然后打电话给SP。

OracleParameter p_ID = new OracleParameter("p_ID", OracleDbType.Decimal, records.Select(x => x.ID).ToArray(), ParameterDirection.Input);

OracleParameter p_FIELD1 = new OracleParameter("p_FIELD1", OracleDbType.Varchar2, records.Select(x => x.FIELD1).ToArray(), ParameterDirection.Input);

OracleParameter p_FIELD2 = new OracleParameter("p_FIELD2", OracleDbType.Varchar2, records.Select(x => x.FIELD2).ToArray(), ParameterDirection.Input);

OracleParameter p_FIELD3 = new OracleParameter("p_FIELD3", OracleDbType.Date, records.Select(x => x.FIELD3).ToArray(), ParameterDirection.Input);

var result = context.Database.ExecuteSqlCommand("BEGIN MY_PACKAGE.MY_PROC(:p_ID, :p_FIELD1, :p_FIELD2, :p_FIELD3); END;", p_ID, p_FIELD1, p_FIELD2, p_FIELD3);

但是我得到错误无法将类型为'Oracle.ManagedDataAccess.Types.OracleDecimal []'的对象强制转换为'System.IConvertible'。

我不知道如何解决这个错误。

当我创建我的列表时，我有以下几点：

OracleDate myDate = new OracleDate(DateTime.Now);

var myRecord = new MyClass

{

ID = ((OracleDecimal)ID).Value,

FIELD1 = field1,

FIELD2 = field2,

FIELD3 = myDate

};

任何建议，将不胜感激。

I am not sure how to resolve this error.

I have a class

public class MyClass

{

public OracleDecimal ID { get; set; }

public string FIELD1 { get; set; }

public string FIELD2 { get; set; }

public OracleDate FIELD3 { get; set; }

}

I built a List then make a call to the SP.

OracleParameter p_ID = new OracleParameter("p_ID", OracleDbType.Decimal, records.Select(x => x.ID).ToArray(), ParameterDirection.Input);

OracleParameter p_FIELD1 = new OracleParameter("p_FIELD1", OracleDbType.Varchar2, records.Select(x => x.FIELD1).ToArray(), ParameterDirection.Input);

OracleParameter p_FIELD2 = new OracleParameter("p_FIELD2", OracleDbType.Varchar2, records.Select(x => x.FIELD2).ToArray(), ParameterDirection.Input);

OracleParameter p_FIELD3 = new OracleParameter("p_FIELD3", OracleDbType.Date, records.Select(x => x.FIELD3).ToArray(), ParameterDirection.Input);

var result = context.Database.ExecuteSqlCommand("BEGIN MY_PACKAGE.MY_PROC(:p_ID, :p_FIELD1, :p_FIELD2, :p_FIELD3); END;", p_ID, p_FIELD1, p_FIELD2, p_FIELD3);

However I get the error Unable to cast object of type 'Oracle.ManagedDataAccess.Types.OracleDecimal[]' to type 'System.IConvertible'.

I'm not sure how to resolve this error.

When I create my list I have the following:

OracleDate myDate = new OracleDate(DateTime.Now);

var myRecord = new MyClass

{

ID = ((OracleDecimal)ID).Value,

FIELD1 = field1,

FIELD2 = field2,

FIELD3 = myDate

};

Any suggestions would be appreciated.

原文：https://stackoverflow.com/questions/40161128

更新时间：2020-05-31 19:05

最满意答案

records.Select(x => ...)将返回值列表，而不是单个值。

你应该围绕foreach循环包装你的代码：

foreach(var record in records)

{

OracleParameter p_ID = new OracleParameter("p_ID", OracleDbType.Decimal, record.Id, ParameterDirection.Input);

OracleParameter p_FIELD1 = new OracleParameter("p_FIELD1", OracleDbType.Varchar2, record.FIELD1, ParameterDirection.Input);

OracleParameter p_FIELD2 = new OracleParameter("p_FIELD2", OracleDbType.Varchar2, records.FIELD2, ParameterDirection.Input);

OracleParameter p_FIELD3 = new OracleParameter("p_FIELD3", OracleDbType.Date, records.FIELD3, ParameterDirection.Input);

var result = context.Database.ExecuteSqlCommand("BEGIN MY_PACKAGE.MY_PROC(:p_ID, :p_FIELD1, :p_FIELD2, :p_FIELD3); END;", p_ID, p_FIELD1, p_FIELD2, p_FIELD3);

}

records.Select(x => ...) will return a list of values, not a single value.

You should wrap your code around a foreach loop:

foreach(var record in records)

{

OracleParameter p_ID = new OracleParameter("p_ID", OracleDbType.Decimal, record.Id, ParameterDirection.Input);

OracleParameter p_FIELD1 = new OracleParameter("p_FIELD1", OracleDbType.Varchar2, record.FIELD1, ParameterDirection.Input);

OracleParameter p_FIELD2 = new OracleParameter("p_FIELD2", OracleDbType.Varchar2, records.FIELD2, ParameterDirection.Input);

OracleParameter p_FIELD3 = new OracleParameter("p_FIELD3", OracleDbType.Date, records.FIELD3, ParameterDirection.Input);

var result = context.Database.ExecuteSqlCommand("BEGIN MY_PACKAGE.MY_PROC(:p_ID, :p_FIELD1, :p_FIELD2, :p_FIELD3); END;", p_ID, p_FIELD1, p_FIELD2, p_FIELD3);

}

2016-10-20

相关问答

哇！！得到了答案。测试解决方案： public static void FiletoSql(MemoryStream fileToPut, MySqlConnection con)

{

byte[] data = fileToPut.ToArray();

try

{

const string preparedCommand =

@"update user_account_statem

...

您正在尝试将DropDownList本身转换为Int32而不是其值。您应该进一步向下钻取控件以在转换之前检索该值。例如， currentCategoryID = Convert.ToInt32(((DropDownList)r.FindControl("DDLCategories")).SelectedItem.Value);

You're trying to convert the DropDownList itself to an Int32 rather than its value.

...

ListViewItem无法转换为整数。您应该将项目文本转换回int或使用它的Tag属性来保持项目的整数值。第一种方法： foreach(ListViewItem selectedItem in listView1.SelectedItems)

{

string text = selectedItem.Text;

simIdElements.Add(Convert.ToInt32(text));

}

第二种方法： for (int i = 0; i < simIdCell

...

下面这些行会导致异常，因为当您传递int[]数组的值时(也不默认使用数组绑定)， OracleCommand参数需要int数据类型。 command.Parameters.Add("@USERID", OracleDbType.Int32);

command.Parameters[0].Value = arrUID;

如果您只想传递单个元素，请使用数组索引号来分配值。 command.Parameters[0].Value = arrUID[0];