DBA Data[Home] [Help] [Dependency Information]

TYPE: MDSYS.SDO_GEOMETRY

Object Details
Object Name: SDO_GEOMETRY
Object Type: TYPE
Owner: MDSYS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
SDO_GTYPE NUMBER

SDO_SRID NUMBER

SDO_POINT TYPESDO_POINT_TYPE

SDO_ELEM_INFO TYPESDO_ELEM_INFO_ARRAY

SDO_ORDINATES TYPESDO_ORDINATE_ARRAY

Methods
Name Parameters Result
GET_GTYPE SELF(SDO_GEOMETRY)
 NUMBER
GET_DIMS SELF(SDO_GEOMETRY)
 NUMBER
GET_LRS_DIM SELF(SDO_GEOMETRY)
 NUMBER
GET_WKB SELF(SDO_GEOMETRY)
 BLOB
GET_WKT SELF(SDO_GEOMETRY)
 CLOB
ST_COORDDIM SELF(SDO_GEOMETRY)
 SMALLINT
ST_ISVALID SELF(SDO_GEOMETRY)
 INTEGER
SDO_GEOMETRY SELF(SDO_GEOMETRY)
WKT(CLOB)
SRID(INTEGER)
 SDO_GEOMETRY
SDO_GEOMETRY SELF(SDO_GEOMETRY)
WKT(VARCHAR2)
SRID(INTEGER)
 SDO_GEOMETRY
SDO_GEOMETRY SELF(SDO_GEOMETRY)
WKB(BLOB)
SRID(INTEGER)
 SDO_GEOMETRY

Dependencies

[top of page]

MDSYS.SDO_GEOMETRY references the following:

SchemaMDSYS
TYPESDO_ELEM_INFO_ARRAY
TYPESDO_ORDINATE_ARRAY
TYPESDO_POINT_TYPE
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
MDSYS.SDO_GEOMETRY is referenced by following:

SchemaAMS
TableAMS_LIST_ENTRIES
SchemaAP
TableAP_EXP_LOCATIONS
SchemaAPPS
Package BodyAMS_EVENTOFFER_PVT - show dependent code
Package BodyAMS_LISTENTRY_PVT - show dependent code
Package BodyAMS_LISTGENERATION_PKG - show dependent code
Package BodyAMS_LISTIMPORT_PVT - show dependent code
Package BodyAMS_LIST_ENTRIES_PKG - show dependent code
Package BodyAMS_LIST_ENTRIES_PVT - show dependent code
Package BodyAMS_REGISTRANTS_PVT - show dependent code
Package BodyAMS_SCRIPTING_PUB - show dependent code
Package BodyAMS_VENUE_PVT - show dependent code
Package BodyAP_VENDOR_PUB_PKG - show dependent code
Package BodyAP_WEB_LOCATIONS_PKG - show dependent code
PL/SQL PackageAP_WEB_LOCATIONS_PKG - show dependent code
Package BodyARH_ADDR_PKG - show dependent code
Package BodyAR_IREC_PAYMENTS - show dependent code
Package BodyASO_PARTY_INT - show dependent code
Package BodyAST_API_RECORDS_V2PKG - show dependent code
Package BodyAST_PARTY_LOCATIONS_V2PUB - show dependent code
Package BodyAS_IMPORT_SL_PVT - show dependent code
Package BodyBEN_ASSIGNMENT_INTERNAL - show dependent code
Package BodyBEN_LOCATION_OBJECT - show dependent code
Package BodyBEN_PERSON_OBJECT - show dependent code
Package BodyCSC_RESPONSE_CENTER_PKG_V2 - show dependent code
Package BodyCSD_PARTIES_PVT - show dependent code
Package BodyCSD_PROCESS_PVT - show dependent code
Package BodyCSFW_SPATIAL_PUB - show dependent code
PL/SQL PackageCSFW_SPATIAL_PUB - show dependent code
Package BodyCSF_DEBRIEF_CHARGES - show dependent code
Package BodyCSF_DEBRIEF_PVT - show dependent code
Package BodyCSF_LF_PUB - show dependent code
PL/SQL PackageCSF_LF_PUB - show dependent code
Package BodyCSF_LOCUS_PUB - show dependent code
PL/SQL PackageCSF_LOCUS_PUB - show dependent code
TableCSF_MD_ADM_BOUNDS_MAT_V
TableCSF_MD_HYDROS_MAT_V
TableCSF_MD_LAND_USES_MAT_V
TableCSF_MD_POIS_MAT_V
TableCSF_MD_RAIL_SEGS_MAT_V
TableCSF_MD_RD_SEGS_FUN0_V
TableCSF_MD_RD_SEGS_FUN1_V
TableCSF_MD_RD_SEGS_FUN2_V
TableCSF_MD_RD_SEGS_FUN3_V
TableCSF_MD_RD_SEGS_FUN4_V
Package BodyCSF_RESOURCE_ADDRESS_PVT - show dependent code
PL/SQL PackageCSF_RESOURCE_ADDRESS_PVT - show dependent code
Package BodyCSF_RESOURCE_PUB - show dependent code
PL/SQL PackageCSF_TASK_ADDRESS_PVT - show dependent code
Package BodyCSF_TASK_ADDRESS_PVT - show dependent code
TableCSF_WOM_ROAD_HIWAY_MAT_V
Package BodyCSI_HZ_LOCATIONS_PVT - show dependent code
Package BodyCSP_LOCATION_PKG - show dependent code
Package BodyCSR_SCHEDULER_PVT - show dependent code
Package BodyCS_SR_CUST_CONT_MAINT_PVT - show dependent code
Package BodyCUG_ADDRESS_CREATION_PKG - show dependent code
Package BodyFND_OID_USERS - show dependent code
PL/SQL PackageFTE_LOCATION_PARAMETERS_PKG - show dependent code
Package BodyFTE_LOCATION_PARAMETERS_PKG - show dependent code
Package BodyFV_CCR_UTIL_PVT - show dependent code
Package BodyGHR_HISTORY_FETCH - show dependent code
Package BodyGHR_MTO_INT - show dependent code
Package BodyGHR_US_NFC_EXTRACTS - show dependent code
ViewHR_LOCATIONS_ALL_VL
Package BodyHR_LOC_INS - show dependent code
Package BodyHR_LOC_SHD - show dependent code
PL/SQL PackageHR_LOC_SHD - show dependent code
Package BodyHR_LOC_UPD - show dependent code
PL/SQL PackageHR_PERSON_RECORD - show dependent code
Package BodyHR_PERSON_RECORD - show dependent code
Package BodyHR_US_REPORTS - show dependent code
Package BodyHZ_CUST_ACCOUNT_MERGE_V2PVT - show dependent code
Package BodyHZ_ELOCATION_PKG - show dependent code
Package BodyHZ_FUZZY_PUB - show dependent code
Package BodyHZ_GEOCODE_PKG - show dependent code
Package BodyHZ_GEOGRAPHIES_PKG - show dependent code
PL/SQL PackageHZ_GEOGRAPHIES_PKG - show dependent code
PL/SQL PackageHZ_GEOGRAPHY_PUB - show dependent code
Package BodyHZ_GEOGRAPHY_PUB - show dependent code
Package BodyHZ_GNR_UTIL_PKG - show dependent code
PL/SQL PackageHZ_LOCATIONS_PKG - show dependent code
Package BodyHZ_LOCATIONS_PKG - show dependent code
Package BodyHZ_LOCATION_BO_PUB - show dependent code
TYPEHZ_LOCATION_OBJ
TYPE BODYHZ_LOCATION_OBJ
Package BodyHZ_LOCATION_SERVICES_PUB - show dependent code
PL/SQL PackageHZ_LOCATION_V2PUB - show dependent code
Package BodyHZ_LOCATION_V2PUB - show dependent code
Package BodyHZ_LOCATION_V2PUB_JW - show dependent code
Package BodyHZ_MAP_PARTY_PUB - show dependent code
Package BodyHZ_PARTY_SITE_BO_PUB - show dependent code
Package BodyHZ_PARTY_SITE_V2PUB - show dependent code
Package BodyIBE_ADDRESS_V2PVT_W - show dependent code
Package BodyIBE_PARTY_V2PVT - show dependent code
Package BodyIBE_PARTY_V2PVT_W - show dependent code
Package BodyIBE_PAYMENT_INT_PVT - show dependent code
Package BodyIBY_ADDRESS_PKG - show dependent code
Package BodyIGI_STP_TABLE_HANDLER_PKG - show dependent code
Package BodyIGS_AD_LOCATION_ADDR_PKG - show dependent code
Package BodyIGS_GR_VENUE_ADDR_PKG - show dependent code
Package BodyIGS_PE_PERSON_ADDR_PKG - show dependent code
Package BodyIGW_ORGANIZATIONS_PVT - show dependent code
Package BodyIGW_SETUP_PERSONS_PVT - show dependent code
Package BodyIRC_ISC_INS - show dependent code
Package BodyIRC_ISC_UPD - show dependent code
Package BodyIRC_LOCATION_UTILITY - show dependent code
PL/SQL PackageIRC_LOCATION_UTILITY - show dependent code
Package BodyIRC_SEEKER_VAC_MATCHING_PKG - show dependent code
PL/SQL PackageIRC_SEEKER_VAC_MATCHING_PKG - show dependent code
Package BodyITG_SYNCSUPPLIERINBOUND_PVT - show dependent code
PL/SQL PackageJTF_RS_UPDATE_LOCATION_PUB - show dependent code
Package BodyJTF_RS_UPDATE_LOCATION_PUB - show dependent code
Package BodyJTF_UM_BUSINESS_USER_PVT - show dependent code
ViewMST_MD_ADM_BOUNDS_V
ViewMST_MD_HYDROS_V
Package BodyOE_INLINE_CUSTOMER_PUB - show dependent code
Package BodyOE_OE_INLINE_ADDRESS - show dependent code
Package BodyOZF_RESALE_COMMON_PVT - show dependent code
Package BodyPAY_US_INDIANA - show dependent code
Package BodyPER_ADDRESSES_PKG - show dependent code
Package BodyPER_ADD_INS - show dependent code
Package BodyPER_ADD_SHD - show dependent code
PL/SQL PackagePER_ADD_SHD - show dependent code
Package BodyPER_ADD_UPD - show dependent code
Package BodyPER_HRTCA_MERGE - show dependent code
Package BodyPER_PEOPLE_V7_PKG - show dependent code
Package BodyPER_QH_MAINTAIN_QUERY - show dependent code
Package BodyPOS_HZ_UTIL_PKG - show dependent code
Package BodyPOS_SBD_IBY_PKG - show dependent code
Package BodyPOS_SUPPLIER_ADDRESS_PKG - show dependent code
Package BodyPO_XML_DELIVERY - show dependent code
Package BodyPQP_HROSS_INTEGRATION - show dependent code
Package BodyPQP_HRTCA_INTEGRATION - show dependent code
Package BodyPQP_PERASGADD_RIW - show dependent code
Package BodyPV_CONTACT_USER_BATCH_PUB - show dependent code
Package BodyPV_LOCATOR - show dependent code
PL/SQL PackagePV_LOCATOR - show dependent code
Package BodyPV_PARTNER_ACCNT_MGMT_PVT - show dependent code
Package BodyPV_PARTNER_UTIL_PVT - show dependent code
ViewRRS_LOCATIONS_V
Package BodyRRS_SITE_UTILS - show dependent code
PL/SQL PackageRRS_SITE_UTILS - show dependent code
Package BodyWSH_CARRIER_ADDRESS_PKG - show dependent code
Package BodyWSH_CREATE_CARRIERS_PKG - show dependent code
Package BodyWSH_GEOCODING - show dependent code
PL/SQL PackageWSH_LOCATIONS_PKG - show dependent code
Package BodyWSH_LOCATIONS_PKG - show dependent code
Package BodyWSH_SUPPLIER_PARTY - show dependent code
SchemaAR
TableHZ_GEOGRAPHIES
TableHZ_LOCATIONS
SchemaCSF
TableCSF_LF_POIS
TableCSF_LF_POSTCODES
TableCSF_LF_ROADSEGMENTS
TableCSF_LF_ROADSEGM_PLACES
TableCSF_MD_ADM_BOUNDS
TableCSF_MD_HYDROS
TableCSF_MD_LAND_USES
TableCSF_MD_LYR_STYLE_SHTS
TableCSF_MD_OM_ADMINS
TableCSF_MD_OM_HYDROS
TableCSF_MD_OM_POIS
TableCSF_MD_OM_ROADS
TableCSF_MD_POIS
TableCSF_MD_RAIL_SEGS
TableCSF_MD_RD_SEGS
TableCSF_SDM_CTRY_PROFILES
TableCSF_TDS_NODES
TableCSF_TDS_ROUTE_CACHE
TableCSF_TDS_TILES
TableCSF_WOM_AREA_COUNTRY
TableCSF_WOM_AREA_LAKE
TableCSF_WOM_AREA_LANDUSE
TableCSF_WOM_AREA_OCEAN
TableCSF_WOM_AREA_STATE
TableCSF_WOM_BOUNDARY_COUNTRY
TableCSF_WOM_BOUNDARY_STATE
TableCSF_WOM_CITY_CAPITAL
TableCSF_WOM_CITY_METROPOLIS
TableCSF_WOM_CITY_SMALL
TableCSF_WOM_POI
TableCSF_WOM_ROAD_HIGHWAY
SchemaHR
TableHR_LOCATIONS_ALL
TableIRC_SEARCH_CRITERIA
TablePER_ADDRESSES
SchemaJTF
TableJTF_RS_RESOURCE_EXTNS
TableJTF_RS_RESOURCE_EXTN_AUD
SchemaMDSYS
TYPE BODYAGGRCENTROID
TYPEAGGRCENTROID
TYPE BODYAGGRCONCAT
TYPEAGGRCONCAT
TYPE BODYAGGRCONVEXHULL
TYPEAGGRCONVEXHULL
TYPE BODYAGGRLRSCONCAT
TYPEAGGRLRSCONCAT
TYPEAGGRLRSCONCAT3D
TYPE BODYAGGRLRSCONCAT3D
TYPEAGGRMBR
TYPE BODYAGGRMBR
TYPE BODYAGGRUNION
TYPEAGGRUNION
ViewALL_SDO_INDEX_METADATA
ViewALL_SDO_STYLES
ViewCS_SRS
TableCS_SRS_ORIG
TriggerCS_SRS_TRIGGER
ViewDBA_SDO_STYLES
OPERATORLOCATOR_WITHIN_DISTANCE
PL/SQL PackageMD2 - show dependent code
Package BodyMD2 - show dependent code
Package BodyMDPRVT_IDX - show dependent code
PL/SQL PackageMDPRVT_IDX - show dependent code
Package BodyMD_LRS - show dependent code
PL/SQL PackageMD_LRS - show dependent code
Package BodyMD_NET - show dependent code
PL/SQL PackageMD_NET - show dependent code
ViewMY_SDO_INDEX_METADATA
TableOLS_DIR_BUSINESSES
TYPE BODYPOINTINPOLYGON_IMP_T
TYPEPOINTINPOLYGON_IMP_T
Package BodyPRVT_IDX - show dependent code
PL/SQL PackagePRVT_IDX - show dependent code
PL/SQL PackagePRVT_PC - show dependent code
Package BodyPRVT_PC - show dependent code
PL/SQL PackagePRVT_SAM - show dependent code
Package BodyPRVT_SAM - show dependent code
Package BodyPRVT_TIN - show dependent code
PL/SQL PackagePRVT_TIN - show dependent code
FunctionQRY2OPT
TYPESDOAGGR
TYPE BODYSDOAGGR
TYPESDOAGGRTYPE
PL/SQL PackageSDO_3GL - show dependent code
Package BodySDO_3GL - show dependent code
PL/SQL PackageSDO_AGGR - show dependent code
Package BodySDO_AGGR - show dependent code
FunctionSDO_AGGR_CENTROID
FunctionSDO_AGGR_CONCAT_LINES
FunctionSDO_AGGR_CONVEXHULL
FunctionSDO_AGGR_LRS_CONCAT
FunctionSDO_AGGR_LRS_CONCAT_3D
FunctionSDO_AGGR_MBR
FunctionSDO_AGGR_SET_UNION
FunctionSDO_AGGR_UNION
OPERATORSDO_ANYINTERACT
OPERATORSDO_CONTAINS
TableSDO_COORD_REF_SYS
ViewSDO_COORD_REF_SYSTEM
OPERATORSDO_COVEREDBY
OPERATORSDO_COVERS
TriggerSDO_CRS_INSERT_TRIGGER
PL/SQL PackageSDO_CS - show dependent code
Package BodySDO_CS - show dependent code
Package BodySDO_CSW_PROCESS - show dependent code
TableSDO_CS_SRS
OPERATORSDO_EQUAL
OPERATORSDO_FILTER
Package BodySDO_GCDR - show dependent code
PL/SQL PackageSDO_GCDR - show dependent code
PL/SQL PackageSDO_GEOM - show dependent code
Package BodySDO_GEOM - show dependent code
TYPE BODYSDO_GEOMETRY
TYPESDO_GEOMETRY_ARRAY
TYPESDO_GEOM_PATH_ELEM
PL/SQL PackageSDO_GEOR - show dependent code
Package BodySDO_GEOR - show dependent code
TYPESDO_GEORASTER
Package BodySDO_GEOR_AGGR - show dependent code
PL/SQL PackageSDO_GEOR_AGGR - show dependent code
Package BodySDO_GEOR_AUX - show dependent code
PL/SQL PackageSDO_GEOR_AUX - show dependent code
PL/SQL PackageSDO_GEOR_INT - show dependent code
Package BodySDO_GEOR_INT - show dependent code
TableSDO_GR_MOSAIC_0
TableSDO_GR_RDT_1
TableSDO_GR_RDT_2
PL/SQL PackageSDO_IDX - show dependent code
Package BodySDO_IDX - show dependent code
TableSDO_INDEX_METADATA_TABLE
TYPE BODYSDO_INDEX_METHOD_10I
TYPESDO_INDEX_METHOD_10I
OPERATORSDO_INSIDE
OPERATORSDO_INT2_FILTER
OPERATORSDO_INT2_RELATE
OPERATORSDO_INT_FILTER
OPERATORSDO_INT_RELATE
PL/SQL PackageSDO_JAVA_STP - show dependent code
TYPESDO_LINK_I
TYPESDO_LINK_I
TYPE BODYSDO_LINK_I
TYPESDO_LINK_T
PL/SQL PackageSDO_LRS - show dependent code
Package BodySDO_LRS - show dependent code
PL/SQL PackageSDO_MIGRATE - show dependent code
Package BodySDO_MIGRATE - show dependent code
Package BodySDO_NET - show dependent code
PL/SQL PackageSDO_NET - show dependent code
TYPESDO_NETWORK_I
TYPESDO_NETWORK_I
TYPE BODYSDO_NETWORK_I
TYPESDO_NETWORK_T
OPERATORSDO_NN
OPERATORSDO_NN_DISTANCE
TYPE BODYSDO_NODE_I
TYPESDO_NODE_I
TYPESDO_NODE_I
TYPESDO_NODE_T
OPERATORSDO_ON
OPERATORSDO_OVERLAPBDYDISJOINT
OPERATORSDO_OVERLAPBDYINTERSECT
OPERATORSDO_OVERLAPS
TYPE BODYSDO_PATH_I
TYPESDO_PATH_I
TYPESDO_PATH_T
TYPESDO_PC
TYPESDO_PC_BLK
TableSDO_PC_BLK_TABLE
PL/SQL PackageSDO_PC_PKG - show dependent code
Package BodySDO_PC_PKG - show dependent code
FunctionSDO_POINTINPOLYGON
FunctionSDO_PQRY
TYPESDO_RASTER
TYPESDO_REGAGGR
TYPESDO_REGION
OPERATORSDO_RELATE
Package BodySDO_RTREE_ADMIN - show dependent code
PL/SQL PackageSDO_RTREE_ADMIN - show dependent code
OPERATORSDO_RTREE_FILTER
OPERATORSDO_RTREE_RELATE
PL/SQL PackageSDO_SAM - show dependent code
Package BodySDO_SAM - show dependent code
FunctionSDO_SIMPLE_FILTER
TYPESDO_SMPL_GEOMETRY
TYPE BODYSDO_STATISTICS
TYPESDO_STATISTICS
TableSDO_STYLES_TABLE
TYPESDO_TIN
TYPESDO_TIN_BLK
TableSDO_TIN_BLK_TABLE
PL/SQL PackageSDO_TIN_PKG - show dependent code
Package BodySDO_TIN_PKG - show dependent code
Package BodySDO_TOPO - show dependent code
PL/SQL PackageSDO_TOPO - show dependent code
TYPESDO_TOPO_GEOMETRY
TYPE BODYSDO_TOPO_GEOMETRY
TYPESDO_TOPO_GEOMETRY
PL/SQL PackageSDO_TOPO_MAP - show dependent code
OPERATORSDO_TOUCH
Package BodySDO_TPFNS - show dependent code
PL/SQL PackageSDO_TPFNS - show dependent code
PL/SQL PackageSDO_TUNE - show dependent code
Package BodySDO_TUNE - show dependent code
Package BodySDO_UTIL - show dependent code
PL/SQL PackageSDO_UTIL - show dependent code
Package BodySDO_WFS_PROCESS - show dependent code
OPERATORSDO_WITHIN_DISTANCE
TYPEST_ANNOTATIONTEXTELEMENT
TYPE BODYST_ANNOTATIONTEXTELEMENT
TYPE BODYST_ANNOTATION_TEXT
TYPEST_ANNOTATION_TEXT
TYPEST_CIRCULARSTRING
TYPE BODYST_CIRCULARSTRING
TYPE BODYST_COMPOUNDCURVE
TYPEST_COMPOUNDCURVE
TYPEST_CURVE
TYPE BODYST_CURVE
TYPE BODYST_CURVEPOLYGON
TYPEST_CURVEPOLYGON
TYPEST_GEOMCOLLECTION
TYPE BODYST_GEOMCOLLECTION
TYPEST_GEOMETRY
TYPE BODYST_GEOMETRY
TYPE BODYST_LINESTRING
TYPEST_LINESTRING
TYPE BODYST_MULTICURVE
TYPEST_MULTICURVE
TYPE BODYST_MULTILINESTRING
TYPEST_MULTILINESTRING
TYPEST_MULTIPOINT
TYPE BODYST_MULTIPOINT
TYPEST_MULTIPOLYGON
TYPE BODYST_MULTIPOLYGON
TYPEST_MULTISURFACE
TYPE BODYST_MULTISURFACE
TYPE BODYST_POINT
TYPEST_POINT
TYPE BODYST_POLYGON
TYPEST_POLYGON
TYPE BODYST_SURFACE
TYPEST_SURFACE
TableUSER_CS_SRS
ViewUSER_SDO_INDEX_METADATA
ViewUSER_SDO_STYLES
SchemaMST
TableMST_MD_ADMIN_BOUNDARIES
TableMST_MD_HYDROS
SchemaPUBLIC
SynonymSDO_GEOMETRY
SchemaRRS
TableRRS_SITE_TMP
TableRRS_TRADE_AREAS
SchemaWSH
TableWSH_LOCATIONS
TableWSH_LOCATION_DATA_EXT