select
FUNC_ID, -- FUNC_ID NUMBER
ARGNUM, -- ARGNUM NUMBER
DATATYPE, -- DATATYPE VARCHAR2(8)
DESCR -- DESCR VARCHAR2(30)
from
GV$SQLFN_ARG_METADATA
where
inst_id=USERENV('Instance')