Invalid st_relate matrix using Oracle error ORA-20012

Last Published: April 25, 2020

Error Message

Executing an Oracle SQL statement with the st_relate operator causes an error when there is an invalid matrix as follows:

2 FROM parcels a, municipal_bnd b
4 AND sde.st_relate(a.shape,b.shape,'*T******') = 1;
SELECT COUNT(*) FROM parcels a, municipal_bnd b
ERROR at line 1:
ORA-20012: Pattern matrix must be 3-by-3 matrix (interior,boundary,exterior)composed of 9 field descriptors.
ORA-06512: at "SDE.ST_RELATION_OPERATORS", line 51
ORA-06512: at "SDE.ST_RELATION_OPERATORS", line 821".


The st_relate operator requires the matrix string to be 9 characters long and consist of any combination of the following characters: 0, 1, 2, *, t, T, f, F. If the matrix is less or more than 9 characters, the ORA-20012 error is encountered.

Solution or Workaround

Validate that the input matrix string contains 9 valid characters.

    Article ID:000010115

    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic