eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

MDSYS.SDO_GEOM dependencies on SDO_GEOMETRY

Line 40: -- layer - SDO geometry table name (LAYER_sdogeom) input argument

36: -- This function generates a unique sequence number for each element of a
37: -- geometric object. The user must ensure that each GID is unique in a
38: -- data set layer.
39: -- ARGUMENTS:
40: -- layer - SDO geometry table name (LAYER_sdogeom) input argument
41: -- gid - Geometry IDentifier input argument
42: -- RETURNS:
43: -- a unique sequence number for each element of a geometric object
44:

Line 52: -- to the SDO geometry table

48:
49: --
50: -- NAME:
51: -- add_nodes - ADD the NODES of the element components of geometric objects
52: -- to the SDO geometry table
53: -- DESCRIPTION:
54: -- This procedure adds vertex coordinates representing the linestring
55: -- segments of the element components of geometric objects to the geometry
56: -- table. A unique sequence number is generated for each row of linestring

Line 199: -- validate_geometry - VALIDATE a GEOMETRY in SDO geometry table

195: */
196:
197: --
198: -- NAME:
199: -- validate_geometry - VALIDATE a GEOMETRY in SDO geometry table
200: -- validate_layer - VALIDATE all geometries in the specified LAYER
201: -- DESCRIPTION:
202: -- validate_geometry function examines the properties of elements of a
203: -- geometry. Coordinates must be within the bounds designated in the

Line 254: -- the same or different SDO geometry tables (LAYER_sdogeom) interact with

250: -- NAME:
251: -- interact - do two geometric objects INTERACT with each other?
252: -- DESCRIPTION:
253: -- This function determines whether or not two geometric objects in either
254: -- the same or different SDO geometry tables (LAYER_sdogeom) interact with
255: -- each other.
256: -- ARGUMENTS:
257: -- layer - geometry table name (LAYER_sdogeom) input argument
258: -- gid - Geometry IDentifier input argument

Line 676: function relate(geom1 IN MDSYS.SDO_GEOMETRY,

672: -- Relate will return 'TRUE' or 'FALSE' for if the following mask is
673: -- specified: 'ANYINTERACT'.
674: --
675:
676: function relate(geom1 IN MDSYS.SDO_GEOMETRY,
677: dim1 IN MDSYS.SDO_DIM_ARRAY,
678: mask IN VARCHAR2,
679: geom2 IN MDSYS.SDO_GEOMETRY,
680: dim2 IN MDSYS.SDO_DIM_ARRAY)

Line 679: geom2 IN MDSYS.SDO_GEOMETRY,

675:
676: function relate(geom1 IN MDSYS.SDO_GEOMETRY,
677: dim1 IN MDSYS.SDO_DIM_ARRAY,
678: mask IN VARCHAR2,
679: geom2 IN MDSYS.SDO_GEOMETRY,
680: dim2 IN MDSYS.SDO_DIM_ARRAY)
681: return VARCHAR2 PARALLEL_ENABLE;
682: -- pragma restrict_references(relate, WNDS, WNPS, RNPS);
683:

Line 685: function relate(geom1 IN MDSYS.SDO_GEOMETRY,

681: return VARCHAR2 PARALLEL_ENABLE;
682: -- pragma restrict_references(relate, WNDS, WNPS, RNPS);
683:
684:
685: function relate(geom1 IN MDSYS.SDO_GEOMETRY,
686: mask IN VARCHAR2,
687: geom2 IN MDSYS.SDO_GEOMETRY,
688: tol IN NUMBER)
689: return VARCHAR2 PARALLEL_ENABLE;

Line 687: geom2 IN MDSYS.SDO_GEOMETRY,

683:
684:
685: function relate(geom1 IN MDSYS.SDO_GEOMETRY,
686: mask IN VARCHAR2,
687: geom2 IN MDSYS.SDO_GEOMETRY,
688: tol IN NUMBER)
689: return VARCHAR2 PARALLEL_ENABLE;
690: -- pragma restrict_references(relate, WNDS, WNPS, RNPS);
691:

Line 717: function within_distance(geom1 IN MDSYS.SDO_GEOMETRY,

713: -- 'TRUE' if the two geometries are within distance of from
714: -- each other, or 'FALSE' otherwise.
715: --
716:
717: function within_distance(geom1 IN MDSYS.SDO_GEOMETRY,
718: dim1 IN MDSYS.SDO_DIM_ARRAY,
719: dist IN NUMBER,
720: geom2 IN MDSYS.SDO_GEOMETRY,
721: dim2 IN MDSYS.SDO_DIM_ARRAY,

Line 720: geom2 IN MDSYS.SDO_GEOMETRY,

716:
717: function within_distance(geom1 IN MDSYS.SDO_GEOMETRY,
718: dim1 IN MDSYS.SDO_DIM_ARRAY,
719: dist IN NUMBER,
720: geom2 IN MDSYS.SDO_GEOMETRY,
721: dim2 IN MDSYS.SDO_DIM_ARRAY,
722: units IN VARCHAR2:=NULL)
723: return VARCHAR2 PARALLEL_ENABLE;
724: -- pragma restrict_references(within_distance, WNDS, WNPS, RNPS);

Line 727: function within_distance(geom1 IN MDSYS.SDO_GEOMETRY,

723: return VARCHAR2 PARALLEL_ENABLE;
724: -- pragma restrict_references(within_distance, WNDS, WNPS, RNPS);
725:
726:
727: function within_distance(geom1 IN MDSYS.SDO_GEOMETRY,
728: dist IN NUMBER,
729: geom2 IN MDSYS.SDO_GEOMETRY,
730: tol IN NUMBER,
731: units IN VARCHAR2:=NULL)

Line 729: geom2 IN MDSYS.SDO_GEOMETRY,

725:
726:
727: function within_distance(geom1 IN MDSYS.SDO_GEOMETRY,
728: dist IN NUMBER,
729: geom2 IN MDSYS.SDO_GEOMETRY,
730: tol IN NUMBER,
731: units IN VARCHAR2:=NULL)
732: return VARCHAR2 PARALLEL_ENABLE;
733: -- pragma restrict_references(within_distance, WNDS, WNPS, RNPS);

Line 757: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,

753: -- This function returns a geometry object representing the buffer
754: -- polygon.
755: --
756:
757: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,
758: dim IN MDSYS.SDO_DIM_ARRAY,
759: dist IN NUMBER)
760: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
761: pragma restrict_references(sdo_buffer, WNDS, WNPS, TRUST);

Line 760: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

756:
757: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,
758: dim IN MDSYS.SDO_DIM_ARRAY,
759: dist IN NUMBER)
760: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
761: pragma restrict_references(sdo_buffer, WNDS, WNPS, TRUST);
762:
763:
764: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,

Line 764: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,

760: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
761: pragma restrict_references(sdo_buffer, WNDS, WNPS, TRUST);
762:
763:
764: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,
765: dist IN NUMBER,
766: tol IN NUMBER)
767: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
768: pragma restrict_references(sdo_buffer, WNDS, WNPS, TRUST);

Line 767: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

763:
764: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,
765: dist IN NUMBER,
766: tol IN NUMBER)
767: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
768: pragma restrict_references(sdo_buffer, WNDS, WNPS, TRUST);
769:
770: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,
771: dim IN MDSYS.SDO_DIM_ARRAY,

Line 770: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,

766: tol IN NUMBER)
767: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
768: pragma restrict_references(sdo_buffer, WNDS, WNPS, TRUST);
769:
770: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,
771: dim IN MDSYS.SDO_DIM_ARRAY,
772: dist IN NUMBER,
773: params IN VARCHAR2)
774: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 774: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

770: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,
771: dim IN MDSYS.SDO_DIM_ARRAY,
772: dist IN NUMBER,
773: params IN VARCHAR2)
774: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
775: pragma restrict_references(sdo_buffer, WNDS, WNPS, TRUST);
776:
777: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,
778: dist IN NUMBER,

Line 777: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,

773: params IN VARCHAR2)
774: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
775: pragma restrict_references(sdo_buffer, WNDS, WNPS, TRUST);
776:
777: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,
778: dist IN NUMBER,
779: tol IN NUMBER,
780: params IN VARCHAR2)
781: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 781: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

777: function sdo_buffer(geom IN MDSYS.SDO_GEOMETRY,
778: dist IN NUMBER,
779: tol IN NUMBER,
780: params IN VARCHAR2)
781: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
782: pragma restrict_references(sdo_buffer, WNDS, WNPS, TRUST);
783:
784:
785: -- Geometry operations

Line 815: function sdo_union(geom1 IN MDSYS.SDO_GEOMETRY,

811: -- RETURNS
812: -- A geometry object representing the result of this geometry operation.
813: --
814:
815: function sdo_union(geom1 IN MDSYS.SDO_GEOMETRY,
816: dim1 IN MDSYS.SDO_DIM_ARRAY,
817: geom2 IN MDSYS.SDO_GEOMETRY,
818: dim2 IN MDSYS.SDO_DIM_ARRAY)
819: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 817: geom2 IN MDSYS.SDO_GEOMETRY,

813: --
814:
815: function sdo_union(geom1 IN MDSYS.SDO_GEOMETRY,
816: dim1 IN MDSYS.SDO_DIM_ARRAY,
817: geom2 IN MDSYS.SDO_GEOMETRY,
818: dim2 IN MDSYS.SDO_DIM_ARRAY)
819: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
820: -- pragma restrict_references(sdo_union, WNDS, WNPS, RNPS);
821:

Line 819: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

815: function sdo_union(geom1 IN MDSYS.SDO_GEOMETRY,
816: dim1 IN MDSYS.SDO_DIM_ARRAY,
817: geom2 IN MDSYS.SDO_GEOMETRY,
818: dim2 IN MDSYS.SDO_DIM_ARRAY)
819: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
820: -- pragma restrict_references(sdo_union, WNDS, WNPS, RNPS);
821:
822: function sdo_self_union(geom1 IN MDSYS.SDO_GEOMETRY,
823: dim1 IN MDSYS.SDO_DIM_ARRAY)

Line 822: function sdo_self_union(geom1 IN MDSYS.SDO_GEOMETRY,

818: dim2 IN MDSYS.SDO_DIM_ARRAY)
819: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
820: -- pragma restrict_references(sdo_union, WNDS, WNPS, RNPS);
821:
822: function sdo_self_union(geom1 IN MDSYS.SDO_GEOMETRY,
823: dim1 IN MDSYS.SDO_DIM_ARRAY)
824: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
825:
826: function sdo_difference(geom1 IN MDSYS.SDO_GEOMETRY,

Line 824: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

820: -- pragma restrict_references(sdo_union, WNDS, WNPS, RNPS);
821:
822: function sdo_self_union(geom1 IN MDSYS.SDO_GEOMETRY,
823: dim1 IN MDSYS.SDO_DIM_ARRAY)
824: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
825:
826: function sdo_difference(geom1 IN MDSYS.SDO_GEOMETRY,
827: dim1 IN MDSYS.SDO_DIM_ARRAY,
828: geom2 IN MDSYS.SDO_GEOMETRY,

Line 826: function sdo_difference(geom1 IN MDSYS.SDO_GEOMETRY,

822: function sdo_self_union(geom1 IN MDSYS.SDO_GEOMETRY,
823: dim1 IN MDSYS.SDO_DIM_ARRAY)
824: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
825:
826: function sdo_difference(geom1 IN MDSYS.SDO_GEOMETRY,
827: dim1 IN MDSYS.SDO_DIM_ARRAY,
828: geom2 IN MDSYS.SDO_GEOMETRY,
829: dim2 IN MDSYS.SDO_DIM_ARRAY)
830: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 828: geom2 IN MDSYS.SDO_GEOMETRY,

824: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
825:
826: function sdo_difference(geom1 IN MDSYS.SDO_GEOMETRY,
827: dim1 IN MDSYS.SDO_DIM_ARRAY,
828: geom2 IN MDSYS.SDO_GEOMETRY,
829: dim2 IN MDSYS.SDO_DIM_ARRAY)
830: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
831: -- pragma restrict_references(sdo_difference, WNDS, WNPS, RNPS);
832:

Line 830: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

826: function sdo_difference(geom1 IN MDSYS.SDO_GEOMETRY,
827: dim1 IN MDSYS.SDO_DIM_ARRAY,
828: geom2 IN MDSYS.SDO_GEOMETRY,
829: dim2 IN MDSYS.SDO_DIM_ARRAY)
830: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
831: -- pragma restrict_references(sdo_difference, WNDS, WNPS, RNPS);
832:
833: function sdo_xor(geom1 IN MDSYS.SDO_GEOMETRY,
834: dim1 IN MDSYS.SDO_DIM_ARRAY,

Line 833: function sdo_xor(geom1 IN MDSYS.SDO_GEOMETRY,

829: dim2 IN MDSYS.SDO_DIM_ARRAY)
830: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
831: -- pragma restrict_references(sdo_difference, WNDS, WNPS, RNPS);
832:
833: function sdo_xor(geom1 IN MDSYS.SDO_GEOMETRY,
834: dim1 IN MDSYS.SDO_DIM_ARRAY,
835: geom2 IN MDSYS.SDO_GEOMETRY,
836: dim2 IN MDSYS.SDO_DIM_ARRAY)
837: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 835: geom2 IN MDSYS.SDO_GEOMETRY,

831: -- pragma restrict_references(sdo_difference, WNDS, WNPS, RNPS);
832:
833: function sdo_xor(geom1 IN MDSYS.SDO_GEOMETRY,
834: dim1 IN MDSYS.SDO_DIM_ARRAY,
835: geom2 IN MDSYS.SDO_GEOMETRY,
836: dim2 IN MDSYS.SDO_DIM_ARRAY)
837: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
838: -- pragma restrict_references(sdo_xor, WNDS, WNPS, RNPS);
839:

Line 837: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

833: function sdo_xor(geom1 IN MDSYS.SDO_GEOMETRY,
834: dim1 IN MDSYS.SDO_DIM_ARRAY,
835: geom2 IN MDSYS.SDO_GEOMETRY,
836: dim2 IN MDSYS.SDO_DIM_ARRAY)
837: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
838: -- pragma restrict_references(sdo_xor, WNDS, WNPS, RNPS);
839:
840: function sdo_intersection(geom1 IN MDSYS.SDO_GEOMETRY,
841: dim1 IN MDSYS.SDO_DIM_ARRAY,

Line 840: function sdo_intersection(geom1 IN MDSYS.SDO_GEOMETRY,

836: dim2 IN MDSYS.SDO_DIM_ARRAY)
837: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
838: -- pragma restrict_references(sdo_xor, WNDS, WNPS, RNPS);
839:
840: function sdo_intersection(geom1 IN MDSYS.SDO_GEOMETRY,
841: dim1 IN MDSYS.SDO_DIM_ARRAY,
842: geom2 IN MDSYS.SDO_GEOMETRY,
843: dim2 IN MDSYS.SDO_DIM_ARRAY)
844: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 842: geom2 IN MDSYS.SDO_GEOMETRY,

838: -- pragma restrict_references(sdo_xor, WNDS, WNPS, RNPS);
839:
840: function sdo_intersection(geom1 IN MDSYS.SDO_GEOMETRY,
841: dim1 IN MDSYS.SDO_DIM_ARRAY,
842: geom2 IN MDSYS.SDO_GEOMETRY,
843: dim2 IN MDSYS.SDO_DIM_ARRAY)
844: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
845: -- pragma restrict_references(sdo_intersection, WNDS, WNPS, RNPS);
846:

Line 844: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

840: function sdo_intersection(geom1 IN MDSYS.SDO_GEOMETRY,
841: dim1 IN MDSYS.SDO_DIM_ARRAY,
842: geom2 IN MDSYS.SDO_GEOMETRY,
843: dim2 IN MDSYS.SDO_DIM_ARRAY)
844: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
845: -- pragma restrict_references(sdo_intersection, WNDS, WNPS, RNPS);
846:
847:
848: function sdo_union(geom1 IN MDSYS.SDO_GEOMETRY,

Line 848: function sdo_union(geom1 IN MDSYS.SDO_GEOMETRY,

844: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
845: -- pragma restrict_references(sdo_intersection, WNDS, WNPS, RNPS);
846:
847:
848: function sdo_union(geom1 IN MDSYS.SDO_GEOMETRY,
849: geom2 IN MDSYS.SDO_GEOMETRY,
850: tol IN NUMBER)
851: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
852: -- pragma restrict_references(sdo_union, WNDS, WNPS, RNPS);

Line 849: geom2 IN MDSYS.SDO_GEOMETRY,

845: -- pragma restrict_references(sdo_intersection, WNDS, WNPS, RNPS);
846:
847:
848: function sdo_union(geom1 IN MDSYS.SDO_GEOMETRY,
849: geom2 IN MDSYS.SDO_GEOMETRY,
850: tol IN NUMBER)
851: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
852: -- pragma restrict_references(sdo_union, WNDS, WNPS, RNPS);
853:

Line 851: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

847:
848: function sdo_union(geom1 IN MDSYS.SDO_GEOMETRY,
849: geom2 IN MDSYS.SDO_GEOMETRY,
850: tol IN NUMBER)
851: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
852: -- pragma restrict_references(sdo_union, WNDS, WNPS, RNPS);
853:
854: function sdo_self_union(geom1 IN MDSYS.SDO_GEOMETRY,
855: tol IN NUMBER)

Line 854: function sdo_self_union(geom1 IN MDSYS.SDO_GEOMETRY,

850: tol IN NUMBER)
851: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
852: -- pragma restrict_references(sdo_union, WNDS, WNPS, RNPS);
853:
854: function sdo_self_union(geom1 IN MDSYS.SDO_GEOMETRY,
855: tol IN NUMBER)
856: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
857:
858: function sdo_difference(geom1 IN MDSYS.SDO_GEOMETRY,

Line 856: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

852: -- pragma restrict_references(sdo_union, WNDS, WNPS, RNPS);
853:
854: function sdo_self_union(geom1 IN MDSYS.SDO_GEOMETRY,
855: tol IN NUMBER)
856: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
857:
858: function sdo_difference(geom1 IN MDSYS.SDO_GEOMETRY,
859: geom2 IN MDSYS.SDO_GEOMETRY,
860: tol IN NUMBER)

Line 858: function sdo_difference(geom1 IN MDSYS.SDO_GEOMETRY,

854: function sdo_self_union(geom1 IN MDSYS.SDO_GEOMETRY,
855: tol IN NUMBER)
856: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
857:
858: function sdo_difference(geom1 IN MDSYS.SDO_GEOMETRY,
859: geom2 IN MDSYS.SDO_GEOMETRY,
860: tol IN NUMBER)
861: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
862: -- pragma restrict_references(sdo_difference, WNDS, WNPS, RNPS);

Line 859: geom2 IN MDSYS.SDO_GEOMETRY,

855: tol IN NUMBER)
856: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
857:
858: function sdo_difference(geom1 IN MDSYS.SDO_GEOMETRY,
859: geom2 IN MDSYS.SDO_GEOMETRY,
860: tol IN NUMBER)
861: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
862: -- pragma restrict_references(sdo_difference, WNDS, WNPS, RNPS);
863:

Line 861: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

857:
858: function sdo_difference(geom1 IN MDSYS.SDO_GEOMETRY,
859: geom2 IN MDSYS.SDO_GEOMETRY,
860: tol IN NUMBER)
861: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
862: -- pragma restrict_references(sdo_difference, WNDS, WNPS, RNPS);
863:
864: function sdo_xor(geom1 IN MDSYS.SDO_GEOMETRY,
865: geom2 IN MDSYS.SDO_GEOMETRY,

Line 864: function sdo_xor(geom1 IN MDSYS.SDO_GEOMETRY,

860: tol IN NUMBER)
861: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
862: -- pragma restrict_references(sdo_difference, WNDS, WNPS, RNPS);
863:
864: function sdo_xor(geom1 IN MDSYS.SDO_GEOMETRY,
865: geom2 IN MDSYS.SDO_GEOMETRY,
866: tol IN NUMBER)
867: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
868: -- pragma restrict_references(sdo_xor, WNDS, WNPS, RNPS);

Line 865: geom2 IN MDSYS.SDO_GEOMETRY,

861: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
862: -- pragma restrict_references(sdo_difference, WNDS, WNPS, RNPS);
863:
864: function sdo_xor(geom1 IN MDSYS.SDO_GEOMETRY,
865: geom2 IN MDSYS.SDO_GEOMETRY,
866: tol IN NUMBER)
867: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
868: -- pragma restrict_references(sdo_xor, WNDS, WNPS, RNPS);
869:

Line 867: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

863:
864: function sdo_xor(geom1 IN MDSYS.SDO_GEOMETRY,
865: geom2 IN MDSYS.SDO_GEOMETRY,
866: tol IN NUMBER)
867: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
868: -- pragma restrict_references(sdo_xor, WNDS, WNPS, RNPS);
869:
870: function sdo_intersection(geom1 IN MDSYS.SDO_GEOMETRY,
871: geom2 IN MDSYS.SDO_GEOMETRY,

Line 870: function sdo_intersection(geom1 IN MDSYS.SDO_GEOMETRY,

866: tol IN NUMBER)
867: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
868: -- pragma restrict_references(sdo_xor, WNDS, WNPS, RNPS);
869:
870: function sdo_intersection(geom1 IN MDSYS.SDO_GEOMETRY,
871: geom2 IN MDSYS.SDO_GEOMETRY,
872: tol IN NUMBER)
873: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
874: -- pragma restrict_references(sdo_intersection, WNDS, WNPS, RNPS);

Line 871: geom2 IN MDSYS.SDO_GEOMETRY,

867: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
868: -- pragma restrict_references(sdo_xor, WNDS, WNPS, RNPS);
869:
870: function sdo_intersection(geom1 IN MDSYS.SDO_GEOMETRY,
871: geom2 IN MDSYS.SDO_GEOMETRY,
872: tol IN NUMBER)
873: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
874: -- pragma restrict_references(sdo_intersection, WNDS, WNPS, RNPS);
875:

Line 873: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

869:
870: function sdo_intersection(geom1 IN MDSYS.SDO_GEOMETRY,
871: geom2 IN MDSYS.SDO_GEOMETRY,
872: tol IN NUMBER)
873: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
874: -- pragma restrict_references(sdo_intersection, WNDS, WNPS, RNPS);
875:
876:
877: -- Deprecated polygon operation interfaces

Line 893: function sdo_poly_union(geom1 IN MDSYS.SDO_GEOMETRY,

889: -- sdo_xor, and sdo_intersection instead of the above polygon specific
890: -- functions.
891: --
892:
893: function sdo_poly_union(geom1 IN MDSYS.SDO_GEOMETRY,
894: dim1 IN MDSYS.SDO_DIM_ARRAY,
895: geom2 IN MDSYS.SDO_GEOMETRY,
896: dim2 IN MDSYS.SDO_DIM_ARRAY)
897: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 895: geom2 IN MDSYS.SDO_GEOMETRY,

891: --
892:
893: function sdo_poly_union(geom1 IN MDSYS.SDO_GEOMETRY,
894: dim1 IN MDSYS.SDO_DIM_ARRAY,
895: geom2 IN MDSYS.SDO_GEOMETRY,
896: dim2 IN MDSYS.SDO_DIM_ARRAY)
897: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
898: -- pragma restrict_references(sdo_poly_union, WNDS, WNPS, RNPS);
899:

Line 897: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

893: function sdo_poly_union(geom1 IN MDSYS.SDO_GEOMETRY,
894: dim1 IN MDSYS.SDO_DIM_ARRAY,
895: geom2 IN MDSYS.SDO_GEOMETRY,
896: dim2 IN MDSYS.SDO_DIM_ARRAY)
897: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
898: -- pragma restrict_references(sdo_poly_union, WNDS, WNPS, RNPS);
899:
900: function sdo_poly_difference(geom1 IN MDSYS.SDO_GEOMETRY,
901: dim1 IN MDSYS.SDO_DIM_ARRAY,

Line 900: function sdo_poly_difference(geom1 IN MDSYS.SDO_GEOMETRY,

896: dim2 IN MDSYS.SDO_DIM_ARRAY)
897: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
898: -- pragma restrict_references(sdo_poly_union, WNDS, WNPS, RNPS);
899:
900: function sdo_poly_difference(geom1 IN MDSYS.SDO_GEOMETRY,
901: dim1 IN MDSYS.SDO_DIM_ARRAY,
902: geom2 IN MDSYS.SDO_GEOMETRY,
903: dim2 IN MDSYS.SDO_DIM_ARRAY)
904: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 902: geom2 IN MDSYS.SDO_GEOMETRY,

898: -- pragma restrict_references(sdo_poly_union, WNDS, WNPS, RNPS);
899:
900: function sdo_poly_difference(geom1 IN MDSYS.SDO_GEOMETRY,
901: dim1 IN MDSYS.SDO_DIM_ARRAY,
902: geom2 IN MDSYS.SDO_GEOMETRY,
903: dim2 IN MDSYS.SDO_DIM_ARRAY)
904: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
905: -- pragma restrict_references(sdo_poly_difference, WNDS, WNPS, RNPS);
906:

Line 904: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

900: function sdo_poly_difference(geom1 IN MDSYS.SDO_GEOMETRY,
901: dim1 IN MDSYS.SDO_DIM_ARRAY,
902: geom2 IN MDSYS.SDO_GEOMETRY,
903: dim2 IN MDSYS.SDO_DIM_ARRAY)
904: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
905: -- pragma restrict_references(sdo_poly_difference, WNDS, WNPS, RNPS);
906:
907: function sdo_poly_xor(geom1 IN MDSYS.SDO_GEOMETRY,
908: dim1 IN MDSYS.SDO_DIM_ARRAY,

Line 907: function sdo_poly_xor(geom1 IN MDSYS.SDO_GEOMETRY,

903: dim2 IN MDSYS.SDO_DIM_ARRAY)
904: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
905: -- pragma restrict_references(sdo_poly_difference, WNDS, WNPS, RNPS);
906:
907: function sdo_poly_xor(geom1 IN MDSYS.SDO_GEOMETRY,
908: dim1 IN MDSYS.SDO_DIM_ARRAY,
909: geom2 IN MDSYS.SDO_GEOMETRY,
910: dim2 IN MDSYS.SDO_DIM_ARRAY)
911: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 909: geom2 IN MDSYS.SDO_GEOMETRY,

905: -- pragma restrict_references(sdo_poly_difference, WNDS, WNPS, RNPS);
906:
907: function sdo_poly_xor(geom1 IN MDSYS.SDO_GEOMETRY,
908: dim1 IN MDSYS.SDO_DIM_ARRAY,
909: geom2 IN MDSYS.SDO_GEOMETRY,
910: dim2 IN MDSYS.SDO_DIM_ARRAY)
911: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
912: -- pragma restrict_references(sdo_poly_xor, WNDS, WNPS, RNPS);
913:

Line 911: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

907: function sdo_poly_xor(geom1 IN MDSYS.SDO_GEOMETRY,
908: dim1 IN MDSYS.SDO_DIM_ARRAY,
909: geom2 IN MDSYS.SDO_GEOMETRY,
910: dim2 IN MDSYS.SDO_DIM_ARRAY)
911: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
912: -- pragma restrict_references(sdo_poly_xor, WNDS, WNPS, RNPS);
913:
914: function sdo_poly_intersection(geom1 IN MDSYS.SDO_GEOMETRY,
915: dim1 IN MDSYS.SDO_DIM_ARRAY,

Line 914: function sdo_poly_intersection(geom1 IN MDSYS.SDO_GEOMETRY,

910: dim2 IN MDSYS.SDO_DIM_ARRAY)
911: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
912: -- pragma restrict_references(sdo_poly_xor, WNDS, WNPS, RNPS);
913:
914: function sdo_poly_intersection(geom1 IN MDSYS.SDO_GEOMETRY,
915: dim1 IN MDSYS.SDO_DIM_ARRAY,
916: geom2 IN MDSYS.SDO_GEOMETRY,
917: dim2 IN MDSYS.SDO_DIM_ARRAY)
918: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 916: geom2 IN MDSYS.SDO_GEOMETRY,

912: -- pragma restrict_references(sdo_poly_xor, WNDS, WNPS, RNPS);
913:
914: function sdo_poly_intersection(geom1 IN MDSYS.SDO_GEOMETRY,
915: dim1 IN MDSYS.SDO_DIM_ARRAY,
916: geom2 IN MDSYS.SDO_GEOMETRY,
917: dim2 IN MDSYS.SDO_DIM_ARRAY)
918: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
919: -- pragma restrict_references(sdo_poly_intersection, WNDS, WNPS, RNPS);
920:

Line 918: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

914: function sdo_poly_intersection(geom1 IN MDSYS.SDO_GEOMETRY,
915: dim1 IN MDSYS.SDO_DIM_ARRAY,
916: geom2 IN MDSYS.SDO_GEOMETRY,
917: dim2 IN MDSYS.SDO_DIM_ARRAY)
918: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
919: -- pragma restrict_references(sdo_poly_intersection, WNDS, WNPS, RNPS);
920:
921:
922: --

Line 946: function sdo_length(geom IN MDSYS.SDO_GEOMETRY,

942: -- RETURNS
943: -- This function returns length or perimeter of a geometry object.
944: --
945:
946: function sdo_length(geom IN MDSYS.SDO_GEOMETRY,
947: dim IN MDSYS.SDO_DIM_ARRAY,
948: unit IN VARCHAR2 DEFAULT NULL,
949: count_shared_edges IN NUMBER DEFAULT NULL)
950: return NUMBER DETERMINISTIC PARALLEL_ENABLE;

Line 954: function sdo_length(geom IN MDSYS.SDO_GEOMETRY,

950: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
951: -- pragma restrict_references(sdo_length, WNDS, WNPS, RNPS);
952:
953:
954: function sdo_length(geom IN MDSYS.SDO_GEOMETRY,
955: tol IN NUMBER,
956: unit IN VARCHAR2 DEFAULT NULL,
957: count_shared_edges IN NUMBER DEFAULT NULL)
958: return NUMBER DETERMINISTIC PARALLEL_ENABLE;

Line 979: function sdo_area(geom IN MDSYS.SDO_GEOMETRY,

975: --
976: -- RETURNS
977: -- This function returns area of a geometry object.
978:
979: function sdo_area(geom IN MDSYS.SDO_GEOMETRY,
980: dim IN MDSYS.SDO_DIM_ARRAY,
981: unit IN VARCHAR2 DEFAULT NULL)
982: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
983: -- pragma restrict_references(sdo_area, WNDS, WNPS, RNPS);

Line 985: function sdo_area(geom IN MDSYS.SDO_GEOMETRY,

981: unit IN VARCHAR2 DEFAULT NULL)
982: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
983: -- pragma restrict_references(sdo_area, WNDS, WNPS, RNPS);
984:
985: function sdo_area(geom IN MDSYS.SDO_GEOMETRY,
986: tol IN NUMBER,
987: unit IN VARCHAR2 DEFAULT NULL)
988: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
989: -- pragma restrict_references(sdo_area, WNDS, WNPS, RNPS);

Line 991: function sdo_volume(geom IN MDSYS.SDO_GEOMETRY,

987: unit IN VARCHAR2 DEFAULT NULL)
988: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
989: -- pragma restrict_references(sdo_area, WNDS, WNPS, RNPS);
990:
991: function sdo_volume(geom IN MDSYS.SDO_GEOMETRY,
992: tol IN NUMBER,
993: unit IN VARCHAR2 DEFAULT NULL)
994: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
995:

Line 1019: function sdo_distance(geom1 IN mdsys.sdo_geometry,

1015: -- RETURNS
1016: -- the minimum distance between the two given geometries.
1017: --
1018:
1019: function sdo_distance(geom1 IN mdsys.sdo_geometry,
1020: dim1 IN mdsys.sdo_dim_array,
1021: geom2 IN mdsys.sdo_geometry,
1022: dim2 IN mdsys.sdo_dim_array,
1023: unit IN varchar2 DEFAULT NULL)

Line 1021: geom2 IN mdsys.sdo_geometry,

1017: --
1018:
1019: function sdo_distance(geom1 IN mdsys.sdo_geometry,
1020: dim1 IN mdsys.sdo_dim_array,
1021: geom2 IN mdsys.sdo_geometry,
1022: dim2 IN mdsys.sdo_dim_array,
1023: unit IN varchar2 DEFAULT NULL)
1024: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1025: --pragma restrict_references(sdo_distance, WNDS, WNPS, RNPS);

Line 1028: function sdo_distance(geom1 IN mdsys.sdo_geometry,

1024: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1025: --pragma restrict_references(sdo_distance, WNDS, WNPS, RNPS);
1026:
1027:
1028: function sdo_distance(geom1 IN mdsys.sdo_geometry,
1029: geom2 IN mdsys.sdo_geometry,
1030: tol IN NUMBER,
1031: unit IN varchar2 DEFAULT NULL)
1032: return NUMBER DETERMINISTIC PARALLEL_ENABLE;

Line 1029: geom2 IN mdsys.sdo_geometry,

1025: --pragma restrict_references(sdo_distance, WNDS, WNPS, RNPS);
1026:
1027:
1028: function sdo_distance(geom1 IN mdsys.sdo_geometry,
1029: geom2 IN mdsys.sdo_geometry,
1030: tol IN NUMBER,
1031: unit IN varchar2 DEFAULT NULL)
1032: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1033: --pragma restrict_references(sdo_distance, WNDS, WNPS, RNPS);

Line 1059: function sdo_maxdistance_line(geom1 IN mdsys.sdo_geometry,

1055: -- the line that has the maximum distance between the two given
1056: -- geometries.
1057: --
1058:
1059: function sdo_maxdistance_line(geom1 IN mdsys.sdo_geometry,
1060: dim1 IN mdsys.sdo_dim_array,
1061: geom2 IN mdsys.sdo_geometry,
1062: dim2 IN mdsys.sdo_dim_array)
1063: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 1061: geom2 IN mdsys.sdo_geometry,

1057: --
1058:
1059: function sdo_maxdistance_line(geom1 IN mdsys.sdo_geometry,
1060: dim1 IN mdsys.sdo_dim_array,
1061: geom2 IN mdsys.sdo_geometry,
1062: dim2 IN mdsys.sdo_dim_array)
1063: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1064:
1065: function sdo_maxdistance_line(geom1 IN mdsys.sdo_geometry,

Line 1063: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1059: function sdo_maxdistance_line(geom1 IN mdsys.sdo_geometry,
1060: dim1 IN mdsys.sdo_dim_array,
1061: geom2 IN mdsys.sdo_geometry,
1062: dim2 IN mdsys.sdo_dim_array)
1063: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1064:
1065: function sdo_maxdistance_line(geom1 IN mdsys.sdo_geometry,
1066: geom2 IN mdsys.sdo_geometry,
1067: tol IN NUMBER)

Line 1065: function sdo_maxdistance_line(geom1 IN mdsys.sdo_geometry,

1061: geom2 IN mdsys.sdo_geometry,
1062: dim2 IN mdsys.sdo_dim_array)
1063: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1064:
1065: function sdo_maxdistance_line(geom1 IN mdsys.sdo_geometry,
1066: geom2 IN mdsys.sdo_geometry,
1067: tol IN NUMBER)
1068: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1069:

Line 1066: geom2 IN mdsys.sdo_geometry,

1062: dim2 IN mdsys.sdo_dim_array)
1063: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1064:
1065: function sdo_maxdistance_line(geom1 IN mdsys.sdo_geometry,
1066: geom2 IN mdsys.sdo_geometry,
1067: tol IN NUMBER)
1068: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1069:
1070: --

Line 1068: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1064:
1065: function sdo_maxdistance_line(geom1 IN mdsys.sdo_geometry,
1066: geom2 IN mdsys.sdo_geometry,
1067: tol IN NUMBER)
1068: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1069:
1070: --
1071: -- NAME:
1072: -- sdo_maxdistance

Line 1093: function sdo_maxdistance(geom1 IN mdsys.sdo_geometry,

1089: -- RETURNS
1090: -- the maximal distance between the two given geometries.
1091: --
1092:
1093: function sdo_maxdistance(geom1 IN mdsys.sdo_geometry,
1094: dim1 IN mdsys.sdo_dim_array,
1095: geom2 IN mdsys.sdo_geometry,
1096: dim2 IN mdsys.sdo_dim_array,
1097: unit IN varchar2 DEFAULT NULL)

Line 1095: geom2 IN mdsys.sdo_geometry,

1091: --
1092:
1093: function sdo_maxdistance(geom1 IN mdsys.sdo_geometry,
1094: dim1 IN mdsys.sdo_dim_array,
1095: geom2 IN mdsys.sdo_geometry,
1096: dim2 IN mdsys.sdo_dim_array,
1097: unit IN varchar2 DEFAULT NULL)
1098: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1099:

Line 1100: function sdo_maxdistance(geom1 IN mdsys.sdo_geometry,

1096: dim2 IN mdsys.sdo_dim_array,
1097: unit IN varchar2 DEFAULT NULL)
1098: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1099:
1100: function sdo_maxdistance(geom1 IN mdsys.sdo_geometry,
1101: geom2 IN mdsys.sdo_geometry,
1102: tol IN NUMBER,
1103: unit IN varchar2 DEFAULT NULL)
1104: return NUMBER DETERMINISTIC PARALLEL_ENABLE;

Line 1101: geom2 IN mdsys.sdo_geometry,

1097: unit IN varchar2 DEFAULT NULL)
1098: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1099:
1100: function sdo_maxdistance(geom1 IN mdsys.sdo_geometry,
1101: geom2 IN mdsys.sdo_geometry,
1102: tol IN NUMBER,
1103: unit IN varchar2 DEFAULT NULL)
1104: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1105:

Line 1122: function sdo_diameter_line(geom IN mdsys.sdo_geometry,

1118: -- RETURNS
1119: -- the line that has the diameter of geometry
1120: --
1121:
1122: function sdo_diameter_line(geom IN mdsys.sdo_geometry,
1123: dim IN mdsys.sdo_dim_array)
1124: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1125:
1126: function sdo_diameter_line(geom IN mdsys.sdo_geometry,

Line 1124: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1120: --
1121:
1122: function sdo_diameter_line(geom IN mdsys.sdo_geometry,
1123: dim IN mdsys.sdo_dim_array)
1124: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1125:
1126: function sdo_diameter_line(geom IN mdsys.sdo_geometry,
1127: tol IN NUMBER)
1128: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 1126: function sdo_diameter_line(geom IN mdsys.sdo_geometry,

1122: function sdo_diameter_line(geom IN mdsys.sdo_geometry,
1123: dim IN mdsys.sdo_dim_array)
1124: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1125:
1126: function sdo_diameter_line(geom IN mdsys.sdo_geometry,
1127: tol IN NUMBER)
1128: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1129:
1130: --

Line 1128: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1124: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1125:
1126: function sdo_diameter_line(geom IN mdsys.sdo_geometry,
1127: tol IN NUMBER)
1128: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1129:
1130: --
1131: -- NAME:
1132: -- sdo_diameter

Line 1147: function sdo_diameter(geom IN mdsys.sdo_geometry,

1143: -- RETURNS
1144: -- the diameter of geometry
1145: --
1146:
1147: function sdo_diameter(geom IN mdsys.sdo_geometry,
1148: dim IN mdsys.sdo_dim_array,
1149: unit IN varchar2 DEFAULT NULL)
1150: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1151:

Line 1152: function sdo_diameter(geom IN mdsys.sdo_geometry,

1148: dim IN mdsys.sdo_dim_array,
1149: unit IN varchar2 DEFAULT NULL)
1150: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1151:
1152: function sdo_diameter(geom IN mdsys.sdo_geometry,
1153: tol IN NUMBER,
1154: unit IN varchar2 DEFAULT NULL)
1155: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1156:

Line 1173: function sdo_width_line(geom IN mdsys.sdo_geometry,

1169: -- RETURNS
1170: -- the line that has the width of geometry
1171: --
1172:
1173: function sdo_width_line(geom IN mdsys.sdo_geometry,
1174: dim IN mdsys.sdo_dim_array)
1175: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1176:
1177: function sdo_width_line(geom IN mdsys.sdo_geometry,

Line 1175: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1171: --
1172:
1173: function sdo_width_line(geom IN mdsys.sdo_geometry,
1174: dim IN mdsys.sdo_dim_array)
1175: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1176:
1177: function sdo_width_line(geom IN mdsys.sdo_geometry,
1178: tol IN NUMBER)
1179: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 1177: function sdo_width_line(geom IN mdsys.sdo_geometry,

1173: function sdo_width_line(geom IN mdsys.sdo_geometry,
1174: dim IN mdsys.sdo_dim_array)
1175: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1176:
1177: function sdo_width_line(geom IN mdsys.sdo_geometry,
1178: tol IN NUMBER)
1179: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1180:
1181: --

Line 1179: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1175: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1176:
1177: function sdo_width_line(geom IN mdsys.sdo_geometry,
1178: tol IN NUMBER)
1179: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1180:
1181: --
1182: -- NAME:
1183: -- sdo_width

Line 1198: function sdo_width(geom IN mdsys.sdo_geometry,

1194: -- RETURNS
1195: -- the width of geometry
1196: --
1197:
1198: function sdo_width(geom IN mdsys.sdo_geometry,
1199: dim IN mdsys.sdo_dim_array,
1200: unit IN varchar2 DEFAULT NULL)
1201: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1202:

Line 1203: function sdo_width(geom IN mdsys.sdo_geometry,

1199: dim IN mdsys.sdo_dim_array,
1200: unit IN varchar2 DEFAULT NULL)
1201: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1202:
1203: function sdo_width(geom IN mdsys.sdo_geometry,
1204: tol IN NUMBER,
1205: unit IN varchar2 DEFAULT NULL)
1206: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1207:

Line 1224: function sdo_mbc(geom IN mdsys.sdo_geometry,

1220: --
1221: -- RETURNS
1222: -- the minimum bounding circle of geometry
1223: --
1224: function sdo_mbc(geom IN mdsys.sdo_geometry,
1225: dim IN mdsys.sdo_dim_array,
1226: arc_tolerance IN NUMBER DEFAULT NULL)
1227: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1228:

Line 1227: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1223: --
1224: function sdo_mbc(geom IN mdsys.sdo_geometry,
1225: dim IN mdsys.sdo_dim_array,
1226: arc_tolerance IN NUMBER DEFAULT NULL)
1227: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1228:
1229: function sdo_mbc(geom IN mdsys.sdo_geometry,
1230: tol IN NUMBER,
1231: arc_tolerance IN NUMBER DEFAULT NULL)

Line 1229: function sdo_mbc(geom IN mdsys.sdo_geometry,

1225: dim IN mdsys.sdo_dim_array,
1226: arc_tolerance IN NUMBER DEFAULT NULL)
1227: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1228:
1229: function sdo_mbc(geom IN mdsys.sdo_geometry,
1230: tol IN NUMBER,
1231: arc_tolerance IN NUMBER DEFAULT NULL)
1232: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1233:

Line 1232: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1228:
1229: function sdo_mbc(geom IN mdsys.sdo_geometry,
1230: tol IN NUMBER,
1231: arc_tolerance IN NUMBER DEFAULT NULL)
1232: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1233:
1234: --
1235: -- NAME:
1236: -- sdo_mbc_center

Line 1249: function sdo_mbc_center(geom IN mdsys.sdo_geometry,

1245: --
1246: -- RETURNS
1247: -- the center of the minimum bounding circle of geometry
1248: --
1249: function sdo_mbc_center(geom IN mdsys.sdo_geometry,
1250: dim IN mdsys.sdo_dim_array)
1251: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1252:
1253: function sdo_mbc_center(geom IN mdsys.sdo_geometry,

Line 1251: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1247: -- the center of the minimum bounding circle of geometry
1248: --
1249: function sdo_mbc_center(geom IN mdsys.sdo_geometry,
1250: dim IN mdsys.sdo_dim_array)
1251: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1252:
1253: function sdo_mbc_center(geom IN mdsys.sdo_geometry,
1254: tol IN NUMBER)
1255: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 1253: function sdo_mbc_center(geom IN mdsys.sdo_geometry,

1249: function sdo_mbc_center(geom IN mdsys.sdo_geometry,
1250: dim IN mdsys.sdo_dim_array)
1251: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1252:
1253: function sdo_mbc_center(geom IN mdsys.sdo_geometry,
1254: tol IN NUMBER)
1255: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1256:
1257: --

Line 1255: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1251: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1252:
1253: function sdo_mbc_center(geom IN mdsys.sdo_geometry,
1254: tol IN NUMBER)
1255: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1256:
1257: --
1258: -- NAME:
1259: -- sdo_mbc_radius

Line 1273: function sdo_mbc_radius(geom IN mdsys.sdo_geometry,

1269: --
1270: -- RETURNS
1271: -- the radius of the minimum bounding circle of geometry
1272: --
1273: function sdo_mbc_radius(geom IN mdsys.sdo_geometry,
1274: dim IN mdsys.sdo_dim_array,
1275: unit IN varchar2 DEFAULT NULL)
1276: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1277:

Line 1278: function sdo_mbc_radius(geom IN mdsys.sdo_geometry,

1274: dim IN mdsys.sdo_dim_array,
1275: unit IN varchar2 DEFAULT NULL)
1276: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1277:
1278: function sdo_mbc_radius(geom IN mdsys.sdo_geometry,
1279: tol IN NUMBER,
1280: unit IN varchar2 DEFAULT NULL)
1281: return NUMBER DETERMINISTIC PARALLEL_ENABLE;
1282:

Line 1304: procedure sdo_closest_points(geom1 IN mdsys.sdo_geometry,

1300: -- geomb - the coordinates of second point of closest approach as a geometry object
1301: --
1302: -- Note that: dim1 and dim2 - dimensions of geom1 and geom2 respectively are computed internally.
1303:
1304: procedure sdo_closest_points(geom1 IN mdsys.sdo_geometry,
1305: geom2 IN mdsys.sdo_geometry,
1306: tolerance IN NUMBER,
1307: unit IN VARCHAR2,
1308: dist OUT NUMBER,

Line 1305: geom2 IN mdsys.sdo_geometry,

1301: --
1302: -- Note that: dim1 and dim2 - dimensions of geom1 and geom2 respectively are computed internally.
1303:
1304: procedure sdo_closest_points(geom1 IN mdsys.sdo_geometry,
1305: geom2 IN mdsys.sdo_geometry,
1306: tolerance IN NUMBER,
1307: unit IN VARCHAR2,
1308: dist OUT NUMBER,
1309: geoma OUT mdsys.sdo_geometry,

Line 1309: geoma OUT mdsys.sdo_geometry,

1305: geom2 IN mdsys.sdo_geometry,
1306: tolerance IN NUMBER,
1307: unit IN VARCHAR2,
1308: dist OUT NUMBER,
1309: geoma OUT mdsys.sdo_geometry,
1310: geomb OUT mdsys.sdo_geometry);
1311: --pragma restrict_references(sdo_closest_points, WNDS, WNPS, RNPS);
1312:
1313:

Line 1310: geomb OUT mdsys.sdo_geometry);

1306: tolerance IN NUMBER,
1307: unit IN VARCHAR2,
1308: dist OUT NUMBER,
1309: geoma OUT mdsys.sdo_geometry,
1310: geomb OUT mdsys.sdo_geometry);
1311: --pragma restrict_references(sdo_closest_points, WNDS, WNPS, RNPS);
1312:
1313:
1314: --

Line 1334: function sdo_convexhull(geom1 IN mdsys.sdo_geometry,

1330: -- RETURNS
1331: -- A geometry object representing the result of polygon operation.
1332: --
1333:
1334: function sdo_convexhull(geom1 IN mdsys.sdo_geometry,
1335: dim1 IN mdsys.sdo_dim_array)
1336: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1337: pragma restrict_references(sdo_convexhull, WNDS, WNPS, RNPS);
1338:

Line 1336: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1332: --
1333:
1334: function sdo_convexhull(geom1 IN mdsys.sdo_geometry,
1335: dim1 IN mdsys.sdo_dim_array)
1336: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1337: pragma restrict_references(sdo_convexhull, WNDS, WNPS, RNPS);
1338:
1339: function sdo_convexhull(geom1 IN mdsys.sdo_geometry,
1340: tol IN NUMBER)

Line 1339: function sdo_convexhull(geom1 IN mdsys.sdo_geometry,

1335: dim1 IN mdsys.sdo_dim_array)
1336: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1337: pragma restrict_references(sdo_convexhull, WNDS, WNPS, RNPS);
1338:
1339: function sdo_convexhull(geom1 IN mdsys.sdo_geometry,
1340: tol IN NUMBER)
1341: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1342: pragma restrict_references(sdo_convexhull, WNDS, WNPS, RNPS);
1343:

Line 1341: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1337: pragma restrict_references(sdo_convexhull, WNDS, WNPS, RNPS);
1338:
1339: function sdo_convexhull(geom1 IN mdsys.sdo_geometry,
1340: tol IN NUMBER)
1341: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1342: pragma restrict_references(sdo_convexhull, WNDS, WNPS, RNPS);
1343:
1344: function sdo_triangulate(geom IN mdsys.sdo_geometry,
1345: tol IN NUMBER)

Line 1344: function sdo_triangulate(geom IN mdsys.sdo_geometry,

1340: tol IN NUMBER)
1341: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1342: pragma restrict_references(sdo_convexhull, WNDS, WNPS, RNPS);
1343:
1344: function sdo_triangulate(geom IN mdsys.sdo_geometry,
1345: tol IN NUMBER)
1346: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1347: pragma restrict_references(sdo_triangulate, WNDS, WNPS, RNPS);
1348:

Line 1346: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1342: pragma restrict_references(sdo_convexhull, WNDS, WNPS, RNPS);
1343:
1344: function sdo_triangulate(geom IN mdsys.sdo_geometry,
1345: tol IN NUMBER)
1346: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1347: pragma restrict_references(sdo_triangulate, WNDS, WNPS, RNPS);
1348:
1349: -- computes the concavehull of the geometry, assuming
1350: -- that points are likely on the boundary,

Line 1353: function sdo_concavehull_boundary(geom IN mdsys.sdo_geometry,

1349: -- computes the concavehull of the geometry, assuming
1350: -- that points are likely on the boundary,
1351: -- length: to stop, when the longest edge in the concave hull
1352: -- is shorter than it.
1353: function sdo_concavehull_boundary(geom IN mdsys.sdo_geometry,
1354: tol IN NUMBER,
1355: length IN NUMBER DEFAULT NULL)
1356: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1357: pragma restrict_references(sdo_concavehull_boundary, WNDS, WNPS, RNPS);

Line 1356: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1352: -- is shorter than it.
1353: function sdo_concavehull_boundary(geom IN mdsys.sdo_geometry,
1354: tol IN NUMBER,
1355: length IN NUMBER DEFAULT NULL)
1356: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1357: pragma restrict_references(sdo_concavehull_boundary, WNDS, WNPS, RNPS);
1358:
1359: -- computes the concavehull of the geometry, assuming
1360: -- that points are not only on the boundary, but also inside.

Line 1362: function sdo_concavehull(geom IN mdsys.sdo_geometry,

1358:
1359: -- computes the concavehull of the geometry, assuming
1360: -- that points are not only on the boundary, but also inside.
1361: -- radius: output, the radius of stopping circle
1362: function sdo_concavehull(geom IN mdsys.sdo_geometry,
1363: tol IN NUMBER,
1364: radius OUT NUMBER)
1365: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1366: pragma restrict_references(sdo_concavehull, WNDS, WNPS, RNPS);

Line 1365: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1361: -- radius: output, the radius of stopping circle
1362: function sdo_concavehull(geom IN mdsys.sdo_geometry,
1363: tol IN NUMBER,
1364: radius OUT NUMBER)
1365: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1366: pragma restrict_references(sdo_concavehull, WNDS, WNPS, RNPS);
1367:
1368: -- computes the concavehull of the geometry, assuming
1369: -- that points are not only on the boundary, but also inside

Line 1370: function sdo_concavehull(geom IN mdsys.sdo_geometry,

1366: pragma restrict_references(sdo_concavehull, WNDS, WNPS, RNPS);
1367:
1368: -- computes the concavehull of the geometry, assuming
1369: -- that points are not only on the boundary, but also inside
1370: function sdo_concavehull(geom IN mdsys.sdo_geometry,
1371: tol IN NUMBER)
1372: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1373: pragma restrict_references(sdo_concavehull, WNDS, WNPS, RNPS);
1374:

Line 1372: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1368: -- computes the concavehull of the geometry, assuming
1369: -- that points are not only on the boundary, but also inside
1370: function sdo_concavehull(geom IN mdsys.sdo_geometry,
1371: tol IN NUMBER)
1372: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1373: pragma restrict_references(sdo_concavehull, WNDS, WNPS, RNPS);
1374:
1375: -- computes the alpha shape of the geometry
1376: -- radius: alpha value = 1/radius

Line 1379: function sdo_alpha_shape(geom IN mdsys.sdo_geometry,

1375: -- computes the alpha shape of the geometry
1376: -- radius: alpha value = 1/radius
1377: -- flag: 0 -> include points and edges,
1378: -- 1 -> doesn't include points and edges
1379: function sdo_alpha_shape(geom IN mdsys.sdo_geometry,
1380: tol IN NUMBER,
1381: radius IN NUMBER DEFAULT NULL,
1382: flag IN BINARY_INTEGER DEFAULT 0)
1383: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 1383: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1379: function sdo_alpha_shape(geom IN mdsys.sdo_geometry,
1380: tol IN NUMBER,
1381: radius IN NUMBER DEFAULT NULL,
1382: flag IN BINARY_INTEGER DEFAULT 0)
1383: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1384:
1385:
1386: --
1387: -- NAME:

Line 1407: function sdo_centroid(geom1 IN mdsys.sdo_geometry,

1403: -- RETURNS
1404: -- A point geometry object representing the centroid.
1405: --
1406:
1407: function sdo_centroid(geom1 IN mdsys.sdo_geometry,
1408: dim1 IN mdsys.sdo_dim_array)
1409: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1410: -- pragma restrict_references(sdo_centroid, WNDS, WNPS, RNPS);
1411:

Line 1409: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1405: --
1406:
1407: function sdo_centroid(geom1 IN mdsys.sdo_geometry,
1408: dim1 IN mdsys.sdo_dim_array)
1409: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1410: -- pragma restrict_references(sdo_centroid, WNDS, WNPS, RNPS);
1411:
1412: function sdo_centroid(geom1 IN mdsys.sdo_geometry,
1413: tol IN NUMBER)

Line 1412: function sdo_centroid(geom1 IN mdsys.sdo_geometry,

1408: dim1 IN mdsys.sdo_dim_array)
1409: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1410: -- pragma restrict_references(sdo_centroid, WNDS, WNPS, RNPS);
1411:
1412: function sdo_centroid(geom1 IN mdsys.sdo_geometry,
1413: tol IN NUMBER)
1414: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1415: --pragma restrict_references(sdo_centroid, WNDS, WNPS, RNPS);
1416:

Line 1414: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1410: -- pragma restrict_references(sdo_centroid, WNDS, WNPS, RNPS);
1411:
1412: function sdo_centroid(geom1 IN mdsys.sdo_geometry,
1413: tol IN NUMBER)
1414: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1415: --pragma restrict_references(sdo_centroid, WNDS, WNPS, RNPS);
1416:
1417: --
1418: -- NAME:

Line 1427: function sdo_mbr(geom IN mdsys.sdo_geometry,

1423: -- of type x003 with (1003,3,3) element. That is a rectangle
1424: -- object in 2 dimensions.
1425: --
1426:
1427: function sdo_mbr(geom IN mdsys.sdo_geometry,
1428: dim IN mdsys.sdo_dim_array)
1429: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1430: --pragma restrict_references(sdo_mbr, WNDS, WNPS, RNPS);
1431:

Line 1429: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1425: --
1426:
1427: function sdo_mbr(geom IN mdsys.sdo_geometry,
1428: dim IN mdsys.sdo_dim_array)
1429: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1430: --pragma restrict_references(sdo_mbr, WNDS, WNPS, RNPS);
1431:
1432: function sdo_mbr(geom IN mdsys.sdo_geometry)
1433: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 1432: function sdo_mbr(geom IN mdsys.sdo_geometry)

1428: dim IN mdsys.sdo_dim_array)
1429: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1430: --pragma restrict_references(sdo_mbr, WNDS, WNPS, RNPS);
1431:
1432: function sdo_mbr(geom IN mdsys.sdo_geometry)
1433: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1434: --pragma restrict_references(sdo_mbr, WNDS, WNPS, RNPS);
1435:
1436: function sdo_g3dconv(geom IN mdsys.sdo_geometry,

Line 1433: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1429: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1430: --pragma restrict_references(sdo_mbr, WNDS, WNPS, RNPS);
1431:
1432: function sdo_mbr(geom IN mdsys.sdo_geometry)
1433: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1434: --pragma restrict_references(sdo_mbr, WNDS, WNPS, RNPS);
1435:
1436: function sdo_g3dconv(geom IN mdsys.sdo_geometry,
1437: dim IN mdsys.sdo_dim_array)

Line 1436: function sdo_g3dconv(geom IN mdsys.sdo_geometry,

1432: function sdo_mbr(geom IN mdsys.sdo_geometry)
1433: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1434: --pragma restrict_references(sdo_mbr, WNDS, WNPS, RNPS);
1435:
1436: function sdo_g3dconv(geom IN mdsys.sdo_geometry,
1437: dim IN mdsys.sdo_dim_array)
1438: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1439: --pragma restrict_references(sdo_g3dconv, WNDS, WNPS, RNPS);
1440:

Line 1438: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1434: --pragma restrict_references(sdo_mbr, WNDS, WNPS, RNPS);
1435:
1436: function sdo_g3dconv(geom IN mdsys.sdo_geometry,
1437: dim IN mdsys.sdo_dim_array)
1438: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1439: --pragma restrict_references(sdo_g3dconv, WNDS, WNPS, RNPS);
1440:
1441: function sdo_g3dconv(geom IN mdsys.sdo_geometry)
1442: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

Line 1441: function sdo_g3dconv(geom IN mdsys.sdo_geometry)

1437: dim IN mdsys.sdo_dim_array)
1438: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1439: --pragma restrict_references(sdo_g3dconv, WNDS, WNPS, RNPS);
1440:
1441: function sdo_g3dconv(geom IN mdsys.sdo_geometry)
1442: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1443: --pragma restrict_references(sdo_g3dconv, WNDS, WNPS, RNPS);
1444:
1445:

Line 1442: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1438: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1439: --pragma restrict_references(sdo_g3dconv, WNDS, WNPS, RNPS);
1440:
1441: function sdo_g3dconv(geom IN mdsys.sdo_geometry)
1442: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1443: --pragma restrict_references(sdo_g3dconv, WNDS, WNPS, RNPS);
1444:
1445:
1446: function sdo_max_mbr_ordinate(geom IN mdsys.sdo_geometry,

Line 1446: function sdo_max_mbr_ordinate(geom IN mdsys.sdo_geometry,

1442: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1443: --pragma restrict_references(sdo_g3dconv, WNDS, WNPS, RNPS);
1444:
1445:
1446: function sdo_max_mbr_ordinate(geom IN mdsys.sdo_geometry,
1447: dim IN mdsys.sdo_dim_array,
1448: ordinate_pos IN NUMBER)
1449: return NUMBER PARALLEL_ENABLE;
1450: pragma restrict_references(sdo_max_mbr_ordinate, WNDS, WNPS, RNPS);

Line 1452: function sdo_max_mbr_ordinate(geom IN mdsys.sdo_geometry,

1448: ordinate_pos IN NUMBER)
1449: return NUMBER PARALLEL_ENABLE;
1450: pragma restrict_references(sdo_max_mbr_ordinate, WNDS, WNPS, RNPS);
1451:
1452: function sdo_max_mbr_ordinate(geom IN mdsys.sdo_geometry,
1453: ordinate_pos IN NUMBER)
1454: return NUMBER PARALLEL_ENABLE;
1455: pragma restrict_references(sdo_max_mbr_ordinate, WNDS, WNPS, RNPS);
1456:

Line 1458: function sdo_min_mbr_ordinate(geom IN mdsys.sdo_geometry,

1454: return NUMBER PARALLEL_ENABLE;
1455: pragma restrict_references(sdo_max_mbr_ordinate, WNDS, WNPS, RNPS);
1456:
1457:
1458: function sdo_min_mbr_ordinate(geom IN mdsys.sdo_geometry,
1459: dim IN mdsys.sdo_dim_array,
1460: ordinate_pos IN NUMBER)
1461: return NUMBER PARALLEL_ENABLE;
1462: pragma restrict_references(sdo_min_mbr_ordinate, WNDS, WNPS, RNPS);

Line 1464: function sdo_min_mbr_ordinate(geom IN mdsys.sdo_geometry,

1460: ordinate_pos IN NUMBER)
1461: return NUMBER PARALLEL_ENABLE;
1462: pragma restrict_references(sdo_min_mbr_ordinate, WNDS, WNPS, RNPS);
1463:
1464: function sdo_min_mbr_ordinate(geom IN mdsys.sdo_geometry,
1465: ordinate_pos IN NUMBER)
1466: return NUMBER PARALLEL_ENABLE;
1467: pragma restrict_references(sdo_min_mbr_ordinate, WNDS, WNPS, RNPS);
1468:

Line 1491: function sdo_pointonsurface(geom1 IN mdsys.sdo_geometry,

1487: -- RETURNS
1488: -- A point geometry object representing the point
1489: --
1490:
1491: function sdo_pointonsurface(geom1 IN mdsys.sdo_geometry,
1492: dim1 IN mdsys.sdo_dim_array)
1493: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1494: pragma restrict_references(sdo_pointonsurface, WNDS, WNPS, RNPS);
1495:

Line 1493: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1489: --
1490:
1491: function sdo_pointonsurface(geom1 IN mdsys.sdo_geometry,
1492: dim1 IN mdsys.sdo_dim_array)
1493: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1494: pragma restrict_references(sdo_pointonsurface, WNDS, WNPS, RNPS);
1495:
1496: function sdo_pointonsurface(geom1 IN mdsys.sdo_geometry,
1497: tol IN NUMBER)

Line 1496: function sdo_pointonsurface(geom1 IN mdsys.sdo_geometry,

1492: dim1 IN mdsys.sdo_dim_array)
1493: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1494: pragma restrict_references(sdo_pointonsurface, WNDS, WNPS, RNPS);
1495:
1496: function sdo_pointonsurface(geom1 IN mdsys.sdo_geometry,
1497: tol IN NUMBER)
1498: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1499: pragma restrict_references(sdo_pointonsurface, WNDS, WNPS, RNPS);
1500:

Line 1498: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1494: pragma restrict_references(sdo_pointonsurface, WNDS, WNPS, RNPS);
1495:
1496: function sdo_pointonsurface(geom1 IN mdsys.sdo_geometry,
1497: tol IN NUMBER)
1498: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1499: pragma restrict_references(sdo_pointonsurface, WNDS, WNPS, RNPS);
1500:
1501:
1502: --

Line 1532: function validate_geometry(theGeometry IN MDSYS.SDO_GEOMETRY,

1528: -- validate_layer procedure populates the given result_table with
1529: -- validation results.
1530: --
1531:
1532: function validate_geometry(theGeometry IN MDSYS.SDO_GEOMETRY,
1533: theDimInfo IN MDSYS.SDO_DIM_ARRAY)
1534: return VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
1535: --pragma restrict_references(validate_geometry, WNDS, WNPS, RNPS);
1536:

Line 1537: function validate_geometry(theGeometry IN MDSYS.SDO_GEOMETRY,

1533: theDimInfo IN MDSYS.SDO_DIM_ARRAY)
1534: return VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
1535: --pragma restrict_references(validate_geometry, WNDS, WNPS, RNPS);
1536:
1537: function validate_geometry(theGeometry IN MDSYS.SDO_GEOMETRY,
1538: tolerance IN NUMBER)
1539: return VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
1540: --pragma restrict_references(validate_geometry, WNDS, WNPS, RNPS);
1541:

Line 1542: function validate_geometry_with_srid(theGeometry IN MDSYS.SDO_GEOMETRY,

1538: tolerance IN NUMBER)
1539: return VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
1540: --pragma restrict_references(validate_geometry, WNDS, WNPS, RNPS);
1541:
1542: function validate_geometry_with_srid(theGeometry IN MDSYS.SDO_GEOMETRY,
1543: tolerance IN NUMBER,
1544: conditional IN VARCHAR2 := 'TRUE',
1545: flag10g IN VARCHAR2 := 'FALSE',
1546: expected_srid IN NUMBER := -1)

Line 1550: function validate_geometry_with_srid(theGeometry IN MDSYS.SDO_GEOMETRY,

1546: expected_srid IN NUMBER := -1)
1547: return VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
1548: --pragma restrict_references(validate_geometry_with_srid, WNDS, WNPS, RNPS);
1549:
1550: function validate_geometry_with_srid(theGeometry IN MDSYS.SDO_GEOMETRY,
1551: theDimInfo IN MDSYS.SDO_DIM_ARRAY,
1552: conditional IN VARCHAR2 := 'TRUE',
1553: flag10g IN VARCHAR2 := 'FALSE',
1554: expected_srid IN NUMBER := -1)

Line 1558: function validate_geometry_with_context(theGeometry IN MDSYS.SDO_GEOMETRY,

1554: expected_srid IN NUMBER := -1)
1555: return VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
1556: --pragma restrict_references(validate_geometry_with_srid, WNDS, WNPS, RNPS);
1557:
1558: function validate_geometry_with_context(theGeometry IN MDSYS.SDO_GEOMETRY,
1559: theDimInfo IN MDSYS.SDO_DIM_ARRAY,
1560: conditional IN VARCHAR2 := 'TRUE',
1561: flag10g IN VARCHAR2 := 'FALSE')
1562: return VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;

Line 1565: function validate_geometry_with_context(theGeometry IN MDSYS.SDO_GEOMETRY,

1561: flag10g IN VARCHAR2 := 'FALSE')
1562: return VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
1563: --pragma restrict_references(validate_geometry_with_context, WNDS, WNPS, RNPS);
1564:
1565: function validate_geometry_with_context(theGeometry IN MDSYS.SDO_GEOMETRY,
1566: tolerance IN NUMBER,
1567: conditional IN VARCHAR2 := 'TRUE',
1568: flag10g IN VARCHAR2 := 'FALSE')
1569: return VARCHAR2 PARALLEL_ENABLE;

Line 1611: function sdo_arc_densify(geom IN mdsys.sdo_geometry,

1607: -- RETURNS
1608: -- A geometry object representing the result of polygon operation.
1609: --
1610:
1611: function sdo_arc_densify(geom IN mdsys.sdo_geometry,
1612: dim IN mdsys.sdo_dim_array,
1613: params IN VARCHAR2)
1614: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1615: pragma restrict_references(sdo_arc_densify, WNDS, WNPS, RNPS);

Line 1614: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1610:
1611: function sdo_arc_densify(geom IN mdsys.sdo_geometry,
1612: dim IN mdsys.sdo_dim_array,
1613: params IN VARCHAR2)
1614: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1615: pragma restrict_references(sdo_arc_densify, WNDS, WNPS, RNPS);
1616:
1617: function sdo_arc_densify(geom IN mdsys.sdo_geometry,
1618: tol IN NUMBER,

Line 1617: function sdo_arc_densify(geom IN mdsys.sdo_geometry,

1613: params IN VARCHAR2)
1614: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1615: pragma restrict_references(sdo_arc_densify, WNDS, WNPS, RNPS);
1616:
1617: function sdo_arc_densify(geom IN mdsys.sdo_geometry,
1618: tol IN NUMBER,
1619: params IN VARCHAR2)
1620: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1621: pragma restrict_references(sdo_arc_densify, WNDS, WNPS, RNPS);

Line 1620: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

1616:
1617: function sdo_arc_densify(geom IN mdsys.sdo_geometry,
1618: tol IN NUMBER,
1619: params IN VARCHAR2)
1620: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1621: pragma restrict_references(sdo_arc_densify, WNDS, WNPS, RNPS);
1622:
1623: function get_dim_array(geom IN MDSYS.SDO_GEOMETRY, tol IN NUMBER)
1624: return MDSYS.SDO_DIM_ARRAY DETERMINISTIC PARALLEL_ENABLE;

Line 1623: function get_dim_array(geom IN MDSYS.SDO_GEOMETRY, tol IN NUMBER)

1619: params IN VARCHAR2)
1620: return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
1621: pragma restrict_references(sdo_arc_densify, WNDS, WNPS, RNPS);
1622:
1623: function get_dim_array(geom IN MDSYS.SDO_GEOMETRY, tol IN NUMBER)
1624: return MDSYS.SDO_DIM_ARRAY DETERMINISTIC PARALLEL_ENABLE;
1625: pragma restrict_references(get_dim_array, WNDS, WNPS, RNPS);
1626:
1627: --

Line 1642: function sdo_is_nurbscurve(geom IN MDSYS.SDO_GEOMETRY)

1638: -- RETURNS
1639: -- TRUE if NURBS curve is present in the geometry, FALSE otherwise.
1640: --
1641:
1642: function sdo_is_nurbscurve(geom IN MDSYS.SDO_GEOMETRY)
1643: return VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
1644: pragma restrict_references(sdo_is_nurbscurve, WNDS, WNPS, RNPS);
1645:
1646: FUNCTION sdo_insert_log_filter(ind_schema IN VARCHAR2,