Some Oracle functions has an additional mandatory argument "tolerance" (See Oracle documentation about tolerance). When generating SQL, the tolerance value should be set.

User can set the values, used for generating SQL, with GeometryTolerance and GeographyTolerance settings. The default values of these settings are 0.005.

var config = OracleEntityProviderConfig.Instance;
config.SpatialOptions.GeometryTolerance = 0.02;
config.SpatialOptions.GeographyTolerance = 0.001;

Dim config = OracleEntityProviderConfig.Instance
config.SpatialOptions.GeometryTolerance = 0.02
config.SpatialOptions.GeographyTolerance = 0.001

Alternatively, you may specify tolerance in the project config file. For this, you need to update or add the configSections element like it is described in the Entity Framework Provider Configuration section and then add the following Devart.Data.Oracle.Entity tag to the configuration tag:

 <Devart.Data.Oracle.Entity xmlns="http://devart.com/schemas/Devart.Data.Oracle.Entity/1.0">
  <SpatialOptions GeometryTolerance="0.02" GeographyTolerance="0.001" />
 </Devart.Data.Oracle.Entity>

Note: If you need to set multiple Entity Framework provider options for dotConnect for Oracle, don't add multiple Devart.Data.Oracle.Entity tags. Specify all settings in one Devart.Data.Oracle.Entity tag.

See Also

Choosing Spatial Service  | Default SRID  | Area and Distance Units  | Spatials Comparison  | Oracle Spatial Engine  | Spatial Type Name Representation