MDSYS.SDO_PC_PKG dependencies on SDO_GEOMETRY

Line 8: pc_extent sdo_geometry default null,

4: basetable varchar2,
5: basecol varchar2,
6: blktable VARCHAR2,
7: ptn_params varchar2,
8: pc_extent sdo_geometry default null,
9: pc_tol NUMBER default 0.0000000000005,
10: pc_tot_dimensions NUMBER default 2,
11: pc_domain sdo_orgscl_type default null,
12: pc_val_attr_tables SDO_STRING_ARRAY default null,

Line 40: ind_dim_qry sdo_geometry,

36:
37: -- works as read if qry params are null
38: FUNCTION CLIP_PC(
39: inp sdo_pc,
40: ind_dim_qry sdo_geometry,
41: other_dim_qry sdo_mbr,
42: qry_min_res number,
43: qry_max_res number,
44: blkno number default null,

Line 54: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;

50: FUNCTION TO_GEOMETRY(pts BLOB, num_pts NUMBER,
51: pc_tot_dim NUMBER, srid NUMBER default null,
52: blk_domain sdo_orgscl_type default null,
53: get_ids NUMBER default NULL)
54: RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
55:
56: FUNCTION GET_PT_IDs(pts BLOB, num_pts NUMBER,
57: pc_tot_dim NUMBER,
58: blk_domain sdo_orgscl_type default null)

Line 77: FUNCTION CLIP_PCAttrs(inp sdo_pc, qry sdo_geometry, blkno number default null)

73:
74:
75: /*
76: -- works as read if qry is null
77: FUNCTION CLIP_PCAttrs(inp sdo_pc, qry sdo_geometry, blkno number default null)
78: RETURN ANYDATASET;
79: FUNCTION CLIP_PC_PtIds(inp sdo_pc, qry sdo_geometry, blkno number default null)
80: RETURN ANYDATASET;
81: */

Line 79: FUNCTION CLIP_PC_PtIds(inp sdo_pc, qry sdo_geometry, blkno number default null)

75: /*
76: -- works as read if qry is null
77: FUNCTION CLIP_PCAttrs(inp sdo_pc, qry sdo_geometry, blkno number default null)
78: RETURN ANYDATASET;
79: FUNCTION CLIP_PC_PtIds(inp sdo_pc, qry sdo_geometry, blkno number default null)
80: RETURN ANYDATASET;
81: */
82:
83: function clip_pc_into_tin(

Line 85: pc_ind_dim_qry sdo_geometry,

81: */
82:
83: function clip_pc_into_tin(
84: pc_inp sdo_pc,
85: pc_ind_dim_qry sdo_geometry,
86: pc_other_dim_qry sdo_mbr,
87: pc_qry_min_res number,
88: pc_qry_max_res number,
89: tin_basetable varchar2,

Line 93: tin_break_lines sdo_geometry default null,

89: tin_basetable varchar2,
90: tin_basecol varchar2,
91: tin_blktable varchar2,
92: tin_ptn_params varchar2 default null,
93: tin_break_lines sdo_geometry default null,
94: tin_stop_lines sdo_geometry default null,
95: tin_void_rgns sdo_geometry default null,
96: tin_clstpcdatatbl varchar2 default null,
97: pc_blkno number default null)

Line 94: tin_stop_lines sdo_geometry default null,

90: tin_basecol varchar2,
91: tin_blktable varchar2,
92: tin_ptn_params varchar2 default null,
93: tin_break_lines sdo_geometry default null,
94: tin_stop_lines sdo_geometry default null,
95: tin_void_rgns sdo_geometry default null,
96: tin_clstpcdatatbl varchar2 default null,
97: pc_blkno number default null)
98: return mdsys.sdo_tin;

Line 95: tin_void_rgns sdo_geometry default null,

91: tin_blktable varchar2,
92: tin_ptn_params varchar2 default null,
93: tin_break_lines sdo_geometry default null,
94: tin_stop_lines sdo_geometry default null,
95: tin_void_rgns sdo_geometry default null,
96: tin_clstpcdatatbl varchar2 default null,
97: pc_blkno number default null)
98: return mdsys.sdo_tin;
99:

Line 104: region sdo_geometry)

100: function create_contour_geometries(
101: pc sdo_pc,
102: sampling_resolution number,
103: elevations sdo_ordinate_array,
104: region sdo_geometry)
105: return sdo_geometry_array;
106:
107: function create_contour_geometries(
108: pc_flat_table varchar2,

Line 105: return sdo_geometry_array;

101: pc sdo_pc,
102: sampling_resolution number,
103: elevations sdo_ordinate_array,
104: region sdo_geometry)
105: return sdo_geometry_array;
106:
107: function create_contour_geometries(
108: pc_flat_table varchar2,
109: srid number,

Line 112: region sdo_geometry)

108: pc_flat_table varchar2,
109: srid number,
110: sampling_resolution number,
111: elevations sdo_ordinate_array,
112: region sdo_geometry)
113: return sdo_geometry_array;
114:
115: /* This procedure takes a 2D Geometry as input and generates
116: two SQL strings which can be appended to a user cursor in the

Line 113: return sdo_geometry_array;

109: srid number,
110: sampling_resolution number,
111: elevations sdo_ordinate_array,
112: region sdo_geometry)
113: return sdo_geometry_array;
114:
115: /* This procedure takes a 2D Geometry as input and generates
116: two SQL strings which can be appended to a user cursor in the
117: where clause. */

Line 118: PROCEDURE get_tile_sql ( geometry IN SDO_GEOMETRY,

114:
115: /* This procedure takes a 2D Geometry as input and generates
116: two SQL strings which can be appended to a user cursor in the
117: where clause. */
118: PROCEDURE get_tile_sql ( geometry IN SDO_GEOMETRY,
119: sql_interior OUT VARCHAR2,
120: sql_boundary OUT VARCHAR2,
121: tolerance IN NUMBER DEFAULT 0.0000005,
122: sdo_level in NUMBER DEFAULT 4,

Line 131: FUNCTION clip_pc_flat (geometry IN SDO_GEOMETRY,

127: of the base table: only numberic and VARCHAR columns allowed.
128: Query Geometry is used to clip the points from the base table.
129: First two colums should be X and Y. SRID is assumed to be the same
130: as the one used in Geometry. */
131: FUNCTION clip_pc_flat (geometry IN SDO_GEOMETRY,
132: table_name IN VARCHAR2,
133: tolerance IN NUMBER,
134: other_dim_qry IN MDSYS.SDO_MBR DEFAULT NULL,
135: mask IN VARCHAR2 DEFAULT 'ANYINTERACT')

Line 142: FUNCTION clip_pc_flat_string (geometry IN SDO_GEOMETRY,

138:
139: /* Same as the above, but return the actual SQL statement instead of the
140: cursor. Users can add additional predicates or select list and
141: execute it. */
142: FUNCTION clip_pc_flat_string (geometry IN SDO_GEOMETRY,
143: table_name IN VARCHAR2,
144: tolerance IN NUMBER,
145: other_dim_qry IN MDSYS.SDO_MBR DEFAULT NULL,
146: mask IN VARCHAR2 DEFAULT 'ANYINTERACT',