Unable to query Oracle Spatial data using fence received error ORA-06512


If querying oracle spatial data using a fence throws error as

ORA-29902: error in executing ODCIIndexStart() routine
ORA-13243: specified operator is not supported for 3- or higher-dimensional R-tree
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 671

This error can occur because of incorrect syntax near Index parameters ('sdo_indx_dims=3 , layer_gtype=curve'); 

Drop and recreate the Index after removing the comma which was inserted in between Index parameters ('sdo_indx_dims=3 layer_gtype=curve'); to resolve this issue.