我只知道oracle存储过程的名字，有没有办法从数据库中读存储过程的参数名称和类型
------解决方案--------------------
SQL> desc user_arguments
Name Type Nullable Default Comments
------------------ ------------- -------- ------- ---------------------------------------------------------------------
OBJECT_NAME VARCHAR2(30) Y Procedure or function name
PACKAGE_NAME VARCHAR2(30) Y Package name
OBJECT_ID NUMBER Object number of the object
OVERLOAD VARCHAR2(40) Y Overload unique identifier
ARGUMENT_NAME VARCHAR2(30) Y Argument name
POSITION NUMBER Position in argument list, or null for function return value
SEQUENCE NUMBER Argument sequence, including all nesting levels
DATA_LEVEL NUMBER Nesting depth of argument for composite types
DATA_TYPE VARCHAR2(30) Y Datatype of the argument
DEFAULT_VALUE LONG Y Default value for the argument
DEFAULT_LENGTH NUMBER Y Length of default value for the argument