# Regd: SDO_UTIL.Bearing_Tilt_For_Points

**user12035460**Feb 14, 2013 8:01 PM

Hi,

I have been trying to get a bearing using the SDO_UTIL.Bearing_Tilt_For_Points function. But when i execute this query it gives me an error.

_Get the first point required by bearing function

**Cursor C1 Is*

*(Select Sdo_Lrs.Convert_To_Lrs_Geom (R.Geometry, 26.61, 29.61) From Digit.Lrs_Current_Segments R Where R.Lrs_Current_Segment_Id = 10283273), 26.72)*

_Get the second point required by bearing function

*(Select Sdo_Lrs.Convert_To_Lrs_Geom (R.Geometry, 26.61, 29.61) From Digit.Lrs_Current_Segments R Where R.Lrs_Current_Segment_Id = 10283273), 26.74)*

*(*

*0.05,* -- Tolerance

*);*

Error report:

ORA-13364: layer dimensionality does not match geometry dimensions

ORA-06512: at "MDSYS.SDO_3GL";, line 2511

ORA-06512: at "MDSYS.SDO_UTIL";, line 1218

ORA-06512: at line 15

13364. 00000 - "layer dimensionality does not match geometry dimensions"

*Cause: The spatial layer has a geometry with a different dimensions than the

dimensions specified for the layer.

*Action: Make sure that all geometries in a layer have the same dimensions

and that they match the dimensions in the SDO_DIM_ARRAY object

for the layer in the USER_SDO_GEOM_METADATA view.

Not sure what the error is?

Any help is appreciated.

Thanks,

L.

I have been trying to get a bearing using the SDO_UTIL.Bearing_Tilt_For_Points function. But when i execute this query it gives me an error.

**Declare****Bearing Number;****Tilt Number;**_Get the first point required by bearing function

**Cursor C1 Is*

**Select Sdo_Lrs.Locate_Pt (***(Select Sdo_Lrs.Convert_To_Lrs_Geom (R.Geometry, 26.61, 29.61) From Digit.Lrs_Current_Segments R Where R.Lrs_Current_Segment_Id = 10283273), 26.72)*

**a1 From dual;**_Get the second point required by bearing function

**Cursor C2 Is****Select Sdo_Lrs.Locate_Pt (***(Select Sdo_Lrs.Convert_To_Lrs_Geom (R.Geometry, 26.61, 29.61) From Digit.Lrs_Current_Segments R Where R.Lrs_Current_Segment_Id = 10283273), 26.74)*

**b1 From dual;****Begin****For X In C1 Loop****for y in c2 loop****Sdo_Util.Bearing_Tilt_For_Points***(*

**X.a1,**-- start point**y.b1,**-- end point*0.05,* -- Tolerance

**Bearing,****Tilt***);*

**End Loop;****end loop;****Dbms_Output.Put_Line('Bearing = ' || Bearing);****Dbms_Output.Put_Line('Tilt = ' || Tilt);****End;**Error report:

ORA-13364: layer dimensionality does not match geometry dimensions

ORA-06512: at "MDSYS.SDO_3GL";, line 2511

ORA-06512: at "MDSYS.SDO_UTIL";, line 1218

ORA-06512: at line 15

13364. 00000 - "layer dimensionality does not match geometry dimensions"

*Cause: The spatial layer has a geometry with a different dimensions than the

dimensions specified for the layer.

*Action: Make sure that all geometries in a layer have the same dimensions

and that they match the dimensions in the SDO_DIM_ARRAY object

for the layer in the USER_SDO_GEOM_METADATA view.

Not sure what the error is?

Any help is appreciated.

Thanks,

L.

- 302 Views
- Tags: none (add)