Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
PL/SQL Record/Table types in 18c database — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

PL/SQL Record/Table types in 18c database

Received Response
6
Views
1
Comments
edited Jan 9, 2019 9:56AM in Database 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!