Forum Stats

  • 3,853,171 Users
  • 2,264,187 Discussions


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

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.

Micke VrolijkNiels Hecker
2 votes

Active · Last Updated