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 @   louiskoo  阅读(138)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示