Question

怎么使用C#对oracle中的自定义类型数据进行操作

Answer 1

oracle数据库number是对应数字（整数或者小数），如string型一定要转成Int或者浮点型：
String str = "123";
String str1 = "123.123" ;
System.out.println(Integer.parseInt(str));
System.out.println(Float.parseFloat(str1));
#region Oracle数据库数据操作
/// <summary>
/// 对Sql Server执行无返回sql,Insert Update Delete
/// </summary>
/// <param name="pSqlStr"></param>
/// <returns></returns>
public static bool ExecuteNonSql(string pSqlStr)
{
OracleConnection conn = new OracleConnection("data source=123;User Id=123;Password=123;");
OracleCommand vAcommand = new OracleCommand(pSqlStr, vAconnection);
int iLoop = 0;
bool vResult = false;

try
{
vAconnection.Open();
iLoop = vAcommand.ExecuteNonQuery();
}
catch (Exception ex)
{
//throw ex;
}
finally
{
vAconnection.Close();
}
if (iLoop > 0)
vResult = true;
else
vResult = false;
return vResult;

}