oracle 存储过程

  1. createorreplace package body package_user AS 
  2.        PROCEDURE  PERSON_QUERY(RS OUT MY_RESULTSET_CURSOR,C OUTINTEGER
  3.         AS 
  4.              BEGIN 
  5.                   OPEN RS FORselect * from emp; 
  6.                   update A set ename='AAA'
  7.                   SELECTCOUNT(*) INTO C from emp; 
  8.         END PERSON_QUERY; 
  9. END
posted @ 2013-04-09 03:05  louiskoo  阅读(138)  评论(0编辑  收藏  举报