调用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;