[CALCITE-3726] Allow declaring type objects

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.23.0
• Labels: pull-request-available
• Assignee: Ritesh
• Reporter: Ritesh
• Created: 12/Jan/20 07:24
• Updated: 24/May/20 12:00
• Resolved: 08/Apr/20 02:57

Description

https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/objects.htm#i7530

e.g. : 

 

employee_typ(315, 'Francis', 'Logan', 'FLOGAN',
        '555.777.2222', '01-MAY-04', 'SA_MAN', 11000, .15, 101, 110, 
         address_typ('376 Mission', 'San Francisco', 'CA', '94222'))

After an object type is defined and installed in the schema, you can use it to declare objects in any SQL block. For example, you can use the object type to specify the datatype of an attribute, column, variable, bind variable, record field, table element, formal parameter, or function result. At run time, instances of the object type are created; that is, objects of that type are instantiated. Each object can hold different values.

Such objects follow the usual scope and instantiation rules. In a block or subprogram, local objects are instantiated when you enter the block or subprogram and cease to exist when you exit. In a package, objects are instantiated when you first reference the package and cease to exist when you end the database session.

Issue Links

• links to: GitHub Pull Request #1750
• links to: GitHub Pull Request #1866

Sub-Tasks

• Support the nested ROW validation while declaring Objects for Type: Closed