Stream ms;
byte[] picbyte;
if ((ms = ofd.OpenFile()) != null)
{
picbyte = new byte[ms.Length];
ms.Position = 0;
ms.Read(picbyte, 0, Convert.ToInt32(ms.Length));
string conn = ConfigurationManager.ConnectionStrings["oradata"].ConnectionString;
OracleConnection oraconn = new OracleConnection(conn);
string sql = "insert into datatest(signature) values(@signature)";
OracleCommand cmd = new OracleCommand(sql, oraconn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@signature", OracleDbType.Blob);
cmd.Parameters["@signature"].Value = picbyte;
oraconn.Open();
cmd.ExecuteNonQuery();//错误提示处
oraconn.Close();
ms.Close();
MessageBox.Show("图片插入成功!");
}
错误提示:ORA-06550: 第 1 行, 第 46 列:PL/SQL: ORA-00936: 缺失表达式;ORA-06550: 第 1 行, 第 7 列:PL/SQL: SQL Statement ignored,小弟没用过存储过程,请教各位高人问题出在什么地方?
byte[] picbyte;
if ((ms = ofd.OpenFile()) != null)
{
picbyte = new byte[ms.Length];
ms.Position = 0;
ms.Read(picbyte, 0, Convert.ToInt32(ms.Length));
string conn = ConfigurationManager.ConnectionStrings["oradata"].ConnectionString;
OracleConnection oraconn = new OracleConnection(conn);
string sql = "insert into datatest(signature) values(@signature)";
OracleCommand cmd = new OracleCommand(sql, oraconn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@signature", OracleDbType.Blob);
cmd.Parameters["@signature"].Value = picbyte;
oraconn.Open();
cmd.ExecuteNonQuery();//错误提示处
oraconn.Close();
ms.Close();
MessageBox.Show("图片插入成功!");
}
错误提示:ORA-06550: 第 1 行, 第 46 列:PL/SQL: ORA-00936: 缺失表达式;ORA-06550: 第 1 行, 第 7 列:PL/SQL: SQL Statement ignored,小弟没用过存储过程,请教各位高人问题出在什么地方?
string sql = "insert into datatest(signature) values(@signature)";
OracleCommand cmd = new OracleCommand(sql, oraconn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@signature", OracleDbType.Blob);
cmd.Parameters["@signature"].Value = picbyte;