26.12 SDO_LRS.FIND_LRS_DIM_POS
Format
SDO_LRS.FIND_LRS_DIM_POS( table_name IN VARCHAR2, column_name IN VARCHAR2 ) RETURN INTEGER;
Description
Returns the position of the measure dimension within the SDO_DIM_ARRAY structure for a specified SDO_GEOMETRY column.
Parameters
Usage Notes
None.
Examples
The following example returns the position of the measure dimension within the SDO_DIM_ARRAY structure for geometries in the ROUTE_GEOMETRY column of the LRS_ROUTES table. (This example uses the definitions from the example in Example of LRS Functions.)
SELECT SDO_LRS.FIND_LRS_DIM_POS('LRS_ROUTES', 'ROUTE_GEOMETRY') FROM DUAL; SDO_LRS.FIND_LRS_DIM_POS('LRS_ROUTES','ROUTE_GEOMETRY') ------------------------------------------------------- 3
Parent topic: SDO_LRS Package (Linear Referencing System)