Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Use plsql types (like associative arrays or referenced type declarations) in SQL object type

Micke VrolijkFeb 11 2022

I mainly use SQL Object types in the PLSQL context, as it allows to create interfaces with multiple implementations. As field types in SQL types are bound to pure SQL definitions, it is not possible to define a field as a reference (TABLE.COLUMN%TYPE) or as a associative array.
It would improve the quality of our plsql code base if this kind of definitions in SQL types are possible, or if a similar PLSQL only type would be possible.

Comments

Post Details

Added on Feb 11 2022
0 comments
85 views