Toad Common Error

When you uprgrade to 10g db adn try to use toad 8.5 version you will not be able to view the package body.
Invalid IN parameter error will be encountered.To solve this change the view all_arguments.
and extra parameter subprogramid is added in 10g Db.and this is not supported in toad versions.

Solution:
Take a backup of all_arguments table,
create view all_arguments1 as select * from all_arguments.
create a view as all_arguments placing the subprogramid as the last column.

CREATE OR REPLACE VIEW all_arguments (owner,
                                      object_name,
                                      package_name,
                                      object_id,
                                      overload,
                                      argument_name,
                                      POSITION,
                                      SEQUENCE,
                                      data_level,
                                      data_type,
                                      DEFAULT_VALUE,
                                      default_length,
                                      in_out,
                                      data_length,
                                      data_precision,
                                      data_scale,
                                      radix,
                                      character_set_name,
                                      type_owner,
                                      type_name,
                                      type_subname,
                                      type_link,
                                      pls_type,
                                      char_length,
                                      char_used,
                                      subprogram_id
                                     )
AS
   SELECT "OWNER", "OBJECT_NAME", "PACKAGE_NAME", "OBJECT_ID", "OVERLOAD",
          "ARGUMENT_NAME", "POSITION", "SEQUENCE", "DATA_LEVEL", "DATA_TYPE",
          "DEFAULT_VALUE", "DEFAULT_LENGTH", "IN_OUT", "DATA_LENGTH",
          "DATA_PRECISION", "DATA_SCALE", "RADIX", "CHARACTER_SET_NAME",
          "TYPE_OWNER", "TYPE_NAME", "TYPE_SUBNAME", "TYPE_LINK", "PLS_TYPE",
          "CHAR_LENGTH", "CHAR_USED", "SUBPROGRAM_ID"
     FROM all_arguments1