CREATE OR REPLACE PROCEDURE test1
AS
BEGIN
update 表1 SET ID=11 WHERE ID=1;
END;
--肯定更新过了 using (OracleConnection connection = new OracleConnection("Data Source=orcl;Persist Security Info=True;User ID=system;Password=orcl"))
{
OracleCommand command = new OracleCommand("test1", connection);
command.CommandType = CommandType.StoredProcedure;
command.Connection.Open();
int result=command.ExecuteNonQuery();
}result 总是为-1
CREATE OR REPLACE PROCEDURE test1
AS
BEGIN
update 表1 SET ID=11 WHERE ID=1;
commit;--别忘了提交
END;
加上commit ,数据变化了。
还是返回-1