666:
667:
668:
669: --
670: -- Convert standard dim info to lrs diminfo by adding an additional measure informaiotn
671: --
672:
673: FUNCTION convert_to_lrs_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,
674: dim_name IN VARCHAR2,
681:
682:
683:
684: --
685: -- Convert standard dim info to lrs diminfo by adding an additional measure informaiotn
686: --
687:
688: FUNCTION convert_to_lrs_dim_array(dim_array IN MDSYS.SDO_DIM_ARRAY,
689: dim_name IN VARCHAR2,
734:
735:
736:
737: --
738: -- Convert standard linestring geometry to an LRS geom segment
739: --
740:
741: FUNCTION convert_to_lrs_geom(standard_geom IN MDSYS.SDO_GEOMETRY,
742: dim_array IN MDSYS.SDO_DIM_ARRAY,
737: --
738: -- Convert standard linestring geometry to an LRS geom segment
739: --
740:
741: FUNCTION convert_to_lrs_geom(standard_geom IN MDSYS.SDO_GEOMETRY,
742: dim_array IN MDSYS.SDO_DIM_ARRAY,
743: m_pos IN INTEGER,
744: start_measure IN NUMBER ,
745: end_measure IN NUMBER )
745: end_measure IN NUMBER )
746: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
747:
748:
749: FUNCTION convert_to_lrs_geom(standard_geom IN MDSYS.SDO_GEOMETRY,
750: dim_array IN MDSYS.SDO_DIM_ARRAY,
751: m_pos IN INTEGER DEFAULT NULL)
752:
753: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
753: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
754:
755:
756:
757: FUNCTION convert_to_lrs_geom(standard_geom IN MDSYS.SDO_GEOMETRY,
758: dim_array IN MDSYS.SDO_DIM_ARRAY,
759: start_measure IN NUMBER ,
760: end_measure IN NUMBER )
761: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
760: end_measure IN NUMBER )
761: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
762:
763:
764: FUNCTION convert_to_lrs_geom(standard_geom IN MDSYS.SDO_GEOMETRY,
765: m_pos IN INTEGER,
766: start_measure IN NUMBER,
767: end_measure IN NUMBER)
768:
768:
769: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
770:
771:
772: FUNCTION convert_to_lrs_geom(standard_geom IN MDSYS.SDO_GEOMETRY,
773: start_measure IN NUMBER,
774: end_measure IN NUMBER)
775:
776: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
775:
776: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
777:
778:
779: FUNCTION convert_to_lrs_geom(standard_geom IN MDSYS.SDO_GEOMETRY,
780: m_pos IN INTEGER)
781:
782: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
783:
783:
784:
785:
786:
787: FUNCTION convert_to_lrs_geom(standard_geom IN MDSYS.SDO_GEOMETRY)
788:
789: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
790:
791:
790:
791:
792:
793:
794: FUNCTION convert_to_lrs_geom_3d(standard_geom IN MDSYS.SDO_GEOMETRY,
795: dim_array IN MDSYS.SDO_DIM_ARRAY,
796: start_measure IN NUMBER DEFAULT NULL,
797: end_measure IN NUMBER DEFAULT NULL)
798: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
797: end_measure IN NUMBER DEFAULT NULL)
798: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
799:
800:
801: FUNCTION convert_to_lrs_geom_3d(standard_geom IN MDSYS.SDO_GEOMETRY,
802: start_measure IN NUMBER DEFAULT NULL,
803: end_measure IN NUMBER DEFAULT NULL)
804: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
805:
806:
807:
808:
809: --
810: -- Convert an LRS geometry to a standard linestring geometry
811: --
812:
813: FUNCTION convert_to_std_geom(lrs_geom IN MDSYS.SDO_GEOMETRY,
814: dim_array IN MDSYS.SDO_DIM_ARRAY)
835:
836:
837:
838: --
839: -- Update standard geometry layer to an LRS geometry layer, metadata is updated as well
840: --
841:
842: FUNCTION convert_to_lrs_layer(table_name IN VARCHAR2,
843: column_name IN VARCHAR2,
876:
877:
878:
879: --
880: -- Update standard geometry layer to an LRS geometry layer, metadata is updated as well
881: --
882:
883: FUNCTION convert_to_std_layer(table_name IN VARCHAR2,
884: column_name IN VARCHAR2)