Oracle.DataAccess的返回值执行非查询(存储过程)

回报价值
对于UPDATE,INSERT和DELETE语句,返回值是受命令影响的行数.对于CREATE TABLE和DROP TABLE语句,返回值为0.对于所有其他类型的语句,返回值为-1.

这就是microsofts docs关于该函数返回值的陈述……这是否意味着如果我调用存储过程,它会返回-1？

为了清楚起见,我应该从成功执行存储过程中获得什么返回值,或者存储过程由于某种原因未能执行…

我确信它会给我一个错误,但有一个实例,它不会执行,它会给我一个返回值？

解决方法

create procedure test1 as 
begin
    null ; --do nothing
end test1 ;
/

create table testtable(a number);
/

create procedure test2 as
begin
    insert into testtable(a) select level from dual connect by level < 5;
end test2  ;
/

create procedure test3 as
begin
    update testtable set a = a-1;
end test3;
/

create procedure test4 as
begin
    delete testtable;
end test4;
/

static int executeProc(string procName,OracleConnection connection ){
                OracleCommand cmd= new OracleCommand(procName,connection);
                cmd.CommandType = CommandType.StoredProcedure;
                return cmd.ExecuteNonQuery();                   
        }
        static void Main(string[] args)
        {
            Console.WriteLine("what does ExecuteNonQuery return?");
            // Connect
            string connectStr = getConnection();
            OracleConnection connection = new OracleConnection(connectStr);
            connection.Open();
            try{
            Console.WriteLine("test1 =>" + executeProc("test1",connection));
            Console.WriteLine("test2 =>" + executeProc("test2",connection));
            Console.WriteLine("test3 =>" + executeProc("test3",connection));
            Console.WriteLine("test4 =>" + executeProc("test4",connection));
            }
            catch (Exception e){
                Console.WriteLine(e.Message);
            }
            Console.WriteLine("Done");
        }

what does ExecuteNonQuery return?
test1 =>-1
test2 =>-1
test3 =>-1
test4 =>-1

/*
drop table testtable;
drop procedure test1;
drop procedure test2;
drop procedure test3;
drop procedure test4;
*/

参考：
http://download.oracle.com/docs/cd/E11882_01/win.112/e18754/OracleCommandClass.htm#i998363
http://forums.oracle.com/forums/thread.jspa?threadID=636182

（编辑：瑞安网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!