oracle 判断某一个存储是否存在

用如下sql语句即可：

SELECT distinct name
  FROM USER_SOURCE
 WHERE TYPE = 'PROCEDURE'
   and name = 'CONTINUEHISORDERPROCESS';