select t.object_name,t.argument_name,t.data_type,t.in_out
from all_arguments t
where t.owner='用户名' and
      t.object_name='存储过程名' and
      t.package_name='包名'