导航

Oracle proceduce 操作影响行数

Posted on 2007-07-03 18:49  小西  阅读(516)  评论(0)    收藏  举报
CREATE procedure aaa(vv OUT FLOAT) is
BEGIN
  vv := -1;
  DELETE FROM a_tmp
  WHERE sno IN (245,246);
 
  vv := SQL%ROWCOUNT;
 
end aaa;