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

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options