Oracle PL/SQL Tutorial/System Tables Data Dictionary/user arguments
Check user_arguments table
<source lang="sql">
SQL> SQL> SELECT object_name, argument_name, overload
2 , POSITION, SEQUENCE, data_level, data_type 3 FROM user_arguments 4 WHERE data_type IN ("LONG","CHAR");
OBJECT_NAME ARGUMENT_NAME
------------------------------
OVERLOAD POSITION SEQUENCE DATA_LEVEL
---------- ---------- ----------
DATA_TYPE
F1
0 1 0
CHAR
SQL> SQL></source>