Frequently asked question

What does 'ST_Geometry is NOT FINAL' mean?

Last Published: April 25, 2020

Answer

The following shows the first line of the output of DESCRIBE ST_GEOMETRY from SQL*Plus:

Code:
SQL> DESCRIBE ST_GEOMETRY
ST_GEOMETRY is NOT FINAL

'NOT FINAL' is a PL/SQL keyword that refers to whether or not an Oracle datatype can serve as a superclass which can have subclasses. By specifying NOT FINAL, it is possible to define instantiatable subclasses of ST_Geomety such as ST_Point, ST_Polygon, etc.

If NOT FINAL was not specified, Oracle defaults to FINAL which would prohibit subclasses.

NOT FINAL does not have anything to do with the completeness of ST_Geometry itself. The ST_Geometry datatype and functions that ship with ArcGIS 9.2 are complete and fully functional.

Article ID:000009069

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic