Oracle PL/SQL Tutorial/System Tables Data Dictionary/user arguments
Check user_arguments table
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>