FAQ: What Does 'ST_Geometry is NOT FINAL' Mean?

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: