DB/Oracle
stored procedure invalid 조회
hani^___^
2012. 7. 3. 17:03
SELECT OBJECT_NAME, OBJECT_TYPE, STATUS
FROM USER_OBJECTS
WHERE OBJECT_TYPE = 'PROCEDURE' AND STATUS != 'VALID'