ArcGIS Server Banner

SQL exception codes for ST_Geometry

SQL exception codes for ST_Geometry

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
When executing SQL queries against ST_Geometry tables in Oracle or PostgreSQL, either a value or an exception code is returned. Exception codes indicate there is a problem with the information passed to the database in the SQL statement.


Exception code Exception text Description
20001 SE_EXP_CTX_INIT An error has occurred initializing the extproc context handle. This is most likely due to a memory allocation error (Oracle only).
20002 SE_EXP_CONVERT_SPREF_ERR Error converting spatial reference.
20003 SE_EXP_OCI_DATATYPE_ERR Error converting geometry type (Oracle only).
20004 SE_EXP_SHAPE_FROM_TEXT_ERR Error generating shape from text.
20005 SE_EXP_NULL_LOB_LOCATOR The LOB locator is invalid (is null).
20006 SE_EXP_TEXT_FROM_SHAPE_ERR Error generating text from shape.
20007 SE_EXP_MEM_ALLOC_ERR Error allocating memory to well-known binary buffer.
20008 SE_EXP_MAX_SHAPE_PTS_EXCEEDED The number of points specified for the shape exceeds the maximum allowed.
20009 SE_EXP_NULL_SRID An invalid spatial reference ID value was specified for the primary shape.
20010 SE_EXP_INVALID_RELATION_FUNCT Invalid spatial relation function specified.
20011 SE_EXP_MAKE_SHAPE_ERR Error generating shape.
20012 SE_EXP_MAKE_COORDREF_ERR Error changing the coordinate reference.
20013 SE_EXP_SHAPE_SIZE_ERR Error getting well-known binary shape size.
20014 SE_EXP_SHAPE_TO_WKB_ERR Error generating shape from well-known binary.
20015 SE_EXP_SHAPE_FROM_BINARY_ERR Error generating shape from binary.
20016 SE_EXP_SHAPE_TO_RECTANGLE_ERR Error generating rectangle from shape.
20017 SE_EXP_INVALID_GOEM_OPER The specified spatial operator is invalid.
20018 SE_EXP_INVALID_GEOM_OP_FUNCT The specified spatial operator function is invalid.
20019 SE_EXP_RELATE_MASK_NULL The ST_Relate matrix is null.
20020 ST_GEOM_MULTIPLE_SRIDS The ST_Geometry column being registered has more than one spatial reference ID (SRID) defined. All rows in the ST_Geometry column must have the same SRID (Oracle only).
38999 SDE_FAILURE Unexpected error; unknown function was called.

Spatial Extender errors


Exception code Exception text Description
20600 SDE_SHAPE_TEXT_ERROR The shape text contains a syntax error.
20601 SDE_INVALID_SRID The specified spatial reference ID does not exist in the database.
20602 SDE_OUT_OF_MEMORY Not enough memory to complete operation.
20603 SDE_INCOMPATIBLE_SREFS The specified spatial reference is not expected (is incompatible).
20604 SDE_INVALID_BYTE_STREAM Invalid binary string was specified.
20605 SDE_INVALID_GEOMETRY_TYPE The specified geometry type for the shape is invalid.
20606 SDE_PARENTHESIS_MISMATCH Parentheses pairs don't match up; check for unclosed parentheses or that you specified the correct number of parentheses pairs for the shape type specified. For example, multipart polygons require an extra set of parentheses.
20607 SDE_TOO_MANY_PARTS A single part shape type was specified with multiple parts.
20608 SDE_TYPE_MISMATCH An unexpected shape type was specified.
20609 SDE_SHAPE_TEXT_TOO_LONG String specified to define the shape exceeds the allocated buffer size.
20610 SDE_INVALID_PARAM_VALUE The specified parameter value is invalid.
20612 SDE_INVALID_GRID_SIZE The specified spatial index grid size is invalid (Oracle only).
20613 SDE_GRID_SIZE_TOO_SMALL The specified spatial index grid size is too small (Oracle only).

Shape library errors

These exceptions are returned when there are problems with the geometry as defined in the SQL statement.


Exception code Exception text Description
20800 SDE_INVALID_SHAPE An invalid shape was specified; cannot be verified.
20801 SDE_INCOMPATIBLE_SHAPES The specified shapes are of incompatible types.
20802 SDE_SHAPE_INTEGRITY_ERROR The shape's geometry is not complete.
20803 SDE_TOO_MANY_POINTS The number of point coordinates provided is more than is allowed for the type of geometry. For example, if inserting or creating a point feature, you should only be specifying one set of coordinates.
20804 SDE_ALL_SLIVERS Sliver factor caused all results to be slivers.
20805 SDE_BUFFER_OUT_OF_BOUNDS Specified buffer falls outside the spatial bounds of the dataset.
20806 SDE_INVALID_SYSTEM_UNITS Invalid x-, y-, z-, or m-units were specified.
20807 SDE_COORD_OUT_OF_BOUNDS One or more of the coordinates provided falls outside the spatial bounds of the dataset.
20808 SDE_INVALID_COORDSYS_ID The specified coordinate system ID is not found in the database.
20809 SDE_INVALID_COORDSYS_DESC The coordinate system description provided does not match any descriptions in the database.
20810 SDE_PROJECTION_ERROR Error projecting shape points.
20811 SDE_POLY_SHELLS_OVERLAP Two donuts or two outer shells overlap.
20812 SDE_TOO_FEW_POINTS The number of point coordinates provided is not sufficient for the type of geometry. For example, if inserting or creating a polygon feature, at least four coordinate sets (x,y; x,y,z; or x,y,z,m coordinates) must be specified.
20813 SDE_INVALID_POLYGON_CLOSURE The defined coordinate points for the polygon do not create a closed polygon (i.e., the first and last coordinate points should be the same).
20814 SDE_INVALID_OUTER_SHELL A polygon outer shell does not completely enclose all donuts for the part.
20815 SDE_ZERO_AREA_POLYGON The definition provided for the polygon feature creates a polygon with no area. For example, if you define the polygon with three points, and the first and third points are the same, the polygon has no area.
20816 SDE_POLYGON_HAS_VERTICAL_LINE The polygon shell contains a vertical line.
20817 SDE_OUTER_SHELLS_OVERLAP One of the multipart areas contains overlapping parts.
20818 SDE_SELF_INTERSECTING Valid shapes do not have self-intersecting lines; therefore, the shapes are invalid due to the presence of self-intersecting lines.
20819 SDE_INVALID_NUM_MEASURES The number of measures specified in the binary is invalid.
20820 SDE_INVALID_NUM_PARTS The number of parts specified in the binary is invalid.
20821 SDE_INVALID_PART_OFFSET The specified part offset is invalid.
20822 SDE_INVALID_PART_SEPARATOR The specified part separator is in the wrong position.
20823 SDE_BINARY_TOO_SMALL Shape won't fit in supplied binary.
20824 SDE_INVALID_ENTITY_TYPE The specified shape entity type is invalid.
20825 SDE_INVALID_BYTE_ORDER The well-known binary shape byte order is invalid.
20826 SDE_INVALID_PARTNUM Specified part doesn't exist in the shape.
20827 SDE_NIL_SHAPE_NOT_ALLOWED A nil shape cannot be specified for a well-known binary.