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
原文地址:https://www.cnblogs.com/liuxinls/p/3009265.html