從StoreProc中尋找程式

從StoreProc中尋找程式
SELECT DISTINCT B.NAME
FROM USER_PROCEDURES A, USER_SOURCE B
WHERE 1 = 1
AND B.NAME = A.OBJECT_NAME
AND UPPER(B.TEXT) LIKE '%PG_CHANGE_STATUS%'