오라클패키지 프로시저 확인

 -- 패키지.프로시저 내용
SELECT ARGUMENT_NAME,DATA_TYPE,IN_OUT,SEQUENCE FROM all_arguments
WHERE object_id =
(SELECT object_id FROM all_objects WHERE owner = 'owner명'
AND object_name ='패키지명'
AND object_type ='PACKAGE')
AND OBJECT_NAME='프로시저명'
ORDER BY Object_Name, Overload, Sequence

-- 프로시저 내용
SELECT ARGUMENT_NAME,DATA_TYPE,IN_OUT,SEQUENCE FROM all_arguments
WHERE object_id =
(SELECT object_id FROM all_objects WHERE owner = 'owner명'
AND object_name ='프로시저명'
AND object_type ='PROCEDURE')
ORDER BY Object_Name, Overload, Sequence

[출처] 오라클패키지 프로시저 확인|작성자 사랑지기