Oracle存储过程获取入参出参(顺序，名字，类型，入参/出参）

调用SQL语句。

--PROCEDURE_NAME为过程名,自行替换要查询的过程名
--POS为参数位置,NAME为参数名，TYPE为参数类型，IN_OUT为入参/出参
SELECT A.POSITION POS,A.ARGUMENT_NAME NAME,A.DATA_TYPE TYPE,A.IN_OUT   FROM SYS.ALL_ARGUMENTS A,USER_OBJECTS D   WHERE A.OBJECT_ID = D.OBJECT_ID AND A.DATA_LEVEL = 0  AND D.OBJECT_TYPE='PROCEDURE'  AND D.OBJECT_NAME='PROCEDURE_NAME' order by pos asc;