Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-3726

Allow declaring type objects

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.23.0
    • Component/s: None

      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.

        Attachments

        There are no Sub-Tasks for this issue.

          Activity

            People

            • Assignee:
              ritesh.kapoor Ritesh
              Reporter:
              ritesh.kapoor Ritesh
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 7.5h
                7.5h