Listing 6: PL/SQL type-related information in ALL_ARGUMENTS

PL/SQL Types for "allargs_test.composites"



ARGUMENT_NAME        DATA_TYPE       TYPE_NAME       TYPE_SUBNAME
-------------------- --------------- --------------- -------------------------

MULTIREC             PL/SQL RECORD   ALLARGS_TEST    MYREC3
  ALL_EMP_INFO       PL/SQL RECORD   ALLARGS_TEST    MYREC2
    EMPNO_INFO       PL/SQL RECORD   ALLARGS_TEST    MYREC1

  ALLEMPS            PL/SQL TABLE    ALLARGS_TEST    INDEXBY_TABLE_OF_RECORDS
NUM_TABLE            PL/SQL TABLE    ALLARGS_TEST    NUMBER_TABLE
RECS_TABLE           PL/SQL TABLE    ALLARGS_TEST    MYREC_TABLE
          PL/SQL RECORD   ALLARGS_TEST    MYREC1

MYOBJECT             OBJECT          ANOBJECT_T
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