Listing 1: Creation of the record TYPE

   TYPE one_argument_rt IS RECORD (
      owner                all_arguments.owner%TYPE,
      package_name         all_arguments.package_name%TYPE,
      object_name          all_arguments.object_name%TYPE,
      overload             PLS_INTEGER, -- from DBMS_DESCRIBE
      position             all_arguments.position%TYPE,
      data_level           all_arguments.data_level%TYPE,
      argument_name        all_arguments.argument_name%TYPE,
      datatype             PLS_INTEGER, -- from DBMS_DESCRIBE
      default_value        PLS_INTEGER, -- from DBMS_DESCRIBE
      in_out               PLS_INTEGER, -- from DBMS_DESCRIBE
      character_set_name   all_arguments.character_set_name%TYPE,
      type_owner           all_arguments.type_owner%TYPE,
      type_name            all_arguments.type_name%TYPE,
      type_subname         all_arguments.type_subname%TYPE,
      type_link            all_arguments.type_link%TYPE,
      pls_type             all_arguments.pls_type%TYPE,
      char_length          all_arguments.char_length%TYPE,
      char_used            all_arguments.char_used%TYPE
   );
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy