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>