PL/SQL Record/Table types in 18c database

Content

There is a difference in the way metadata is populated in "USER_ARGUMENTS"  (SYS table) for RECORD and TABLE types between 12c and 18c databases. For same stored procedure, in 12c, 5 entries are created while in 18c, 3 entries are created for the user defined types PL/SQL types. Entries that are missing in 18c belongs to Record types arguments information. We rely on this information to derive Record and Table types message shapes.

 

Database entries for 12c - USER_ARGUMENTS

PACKAGE_NAME

TYPE_NAME

TYPE_SUBNAME

OBJECT_NAME

OVERLOAD

ARGUMENT_NAME

IN_OUT

DATA_TYPE

PLS_TYPE

DATA_LEVEL