Introduction, 2 of 2

Summary of Oracle Supplied PL/SQL Packages

Table 1-1 lists the supplied PL/SQL server packages. These packages run as the invoking user, rather than the package owner. Unless otherwise noted, the packages are callable through public synonyms of the same name.

Caution:

The procedures and functions provided in these packages and their external interfaces are reserved by Oracle and are subject to change.
Modifying Oracle supplied packages can cause internal errors and database security violations. Do not modify supplied packages.

Table 1-1 Summary of Oracle Supplied PL/SQL Packages

Package Name	Description	Documentation
`CWM2_OLAP_AW_ACCESS`	Generates scripts that create relational views of analytic workspace objects.	Oracle9i OLAP User's Guide
`DBMS_ALERT`	Provides support for the asynchronous notification of database events.	Chapter 2
`DBMS_APPLICATION_INFO`	Lets you register an application name with the database for auditing or performance tracking purposes.	Chapter 3
`DBMS_APPLY_ADM`	Provides administrative procedures to start, stop, and configure an apply process.	Chapter 4
`DBMS_AQ`	Lets you add a message (of a predefined object type) onto a queue or to dequeue a message.	Chapter 5
`DBMS_AQADM`	Lets you perform administrative functions on a queue or queue table for messages of a predefined object type.	Chapter 6
`DBMS_AQELM`	Provides procedures to manage the configuration of Advanced Queuing asynchronous notification by e-mail and HTTP.	Chapter 7
`DBMS_AW`	Issues OLAP DML statements against analytic workspace objects. Also, lets you retrieve and print the session logs created by the execution of the procedures and functions in this package and the `OLAP_TABLE` function.	Oracle9i OLAP User's Guide
`DBMS_CAPTURE_ADM`	Describes administrative procedures to start, stop, and configure a capture process; used in Streams.	Chapter 8
`DBMS_DDL`	Provides access to some SQL DDL statements from stored procedures, and provides special administration operations not available as DDLs.	Chapter 9
`DBMS_DEBUG`	Implements server-side debuggers and provides a way to debug server-side PL/SQL program units.	Chapter 10
`DBMS_DEFER`	Provides the user interface to a replicated transactional deferred remote procedure call facility. Requires the Distributed Option.	Chapter 11
`DBMS_DEFER_QUERY`	Permits querying the deferred remote procedure calls (RPC) queue data that is not exposed through views. Requires the Distributed Option.	Chapter 12
`DMBS_DEFER_SYS`	Provides the system administrator interface to a replicated transactional deferred remote procedure call facility. Requires the Distributed Option.	Chapter 13
`DBMS_DESCRIBE`	Describes the arguments of a stored procedure with full name translation and security checking.	Chapter 14
`DBMS_DISTRIBUTED_TRUST_ADMIN`	Maintains the Trusted Database List, which is used to determine if a privileged database link from a particular server can be accepted.	Chapter 15
`DBMS_FGA`	Provides fine-grained security functions.	Chapter 16
`DMBS_FLASHBACK`	Lets you flash back to a version of the database at a specified wall-clock time or a specified system change number (SCN).	Chapter 17
`DBMS_HS_PASSTHROUGH`	Lets you use Heterogeneous Services to send pass-through SQL statements to non-Oracle systems.	Chapter 18
`DBMS_IOT`	Creates a table into which references to the chained rows for an Index Organized Table can be placed using the `ANALYZE` command.	Chapter 19
`DBMS_JOB`	Lets you schedule administrative procedures that you want performed at periodic intervals; it is also the interface for the job queue.	Chapter 20
`DBMS_LDAP`	Provides functions and procedures to access data from LDAP servers.	Chapter 21
`DBMS_LIBCACHE`	Prepares the library cache on an Oracle instance by extracting SQL and PL/SQL from a remote instance and compiling this SQL locally without execution.	Chapter 22
`DBMS_LOB`	Provides general purpose routines for operations on Oracle Large Object (`LOB`s) datatypes - `BLOB`, `CLOB` (read/write), and `BFILE`s (read-only).	Chapter 23
`DBMS_LOCK`	Lets you request, convert and release locks through Oracle Lock Management services.	Chapter 24
`DBMS_LOGMNR`	Provides functions to initialize and run the log reader.	Chapter 25
`DBMS_LOGMNR_CDC_PUBLISH`	Identifies new data that has been added to, modified, or removed from, relational tables and publishes the changed data in a form that is usable by an application.	Chapter 26
`DBMS_LOGMNR_CDC_SUBSCRIBE`	Lets you view and query the change data that was captured and published with the `DBMS_LOGMNR_CDC_PUBLISH` package.	Chapter 27
`DBMS_LOGMNR_D`	Queries the dictionary tables of the current database, and creates a text based file containing their contents.	Chapter 28
`DBMS_LOGSTDBY`	Describes procedures for configuring and managing the logical standby database environment.	Chapter 29
`DBMS_METADATA`	Lets callers easily retrieve complete database object definitions (metadata) from the dictionary.	Chapter 30
`DBMS_MGWADM`	Describes the Messaging Gateway administrative interface; used in Advanced Queuing.	Chapter 31
`DBMS_MGWMSG`	Describes object types--used by the canonical message types to convert message bodies--and helper methods, constants, and subprograms for working with the Messaging Gateway message types; used in Advanced Queuing.	Chapter 32
`DBMS_MVIEW`	Lets you refresh snapshots that are not part of the same refresh group and purge logs. `DBMS_SNAPSHOT` is a synonym.	Chapter 33
`DBMS_OBFUSCATION_TOOLKIT`	Provides procedures for Data Encryption Standards.	Chapter 34
`DBMS_ODCI`	Returns the CPU cost of a user function based on the elapsed time of the function.	Chapter 35
`DBMS_OFFLINE_OG`	Provides public APIs for offline instantiation of master groups.	Chapter 36
`DBMS_OFFLINE_SNAPSHOT`	Provides public APIs for offline instantiation of snapshots.	Chapter 37
`DBMS_OLAP`	Provides procedures for summaries, dimensions, and query rewrites.	Chapter 38
`DBMS_ORACLE_TRACE_AGENT`	Provides client callable interfaces to the Oracle TRACE instrumentation within the Oracle7 Server.	Chapter 39
`DBMS_ORACLE_TRACE_USER`	Provides public access to the Oracle release 7 Server Oracle TRACE instrumentation for the calling user.	Chapter 40
`DBMS_OUTLN`	Provides the interface for procedures and functions associated with management of stored outlines. Synonymous with `OUTLN_PKG`	Chapter 41
`DBMS_OUTLN_EDIT`	Lets you edit an invoker's rights package.	Chapter 42
`DBMS_OUTPUT`	Accumulates information in a buffer so that it can be retrieved out later.	Chapter 43
`DBMS_PCLXUTIL`	Provides intra-partition parallelism for creating partition-wise local indexes.	Chapter 44
`DBMS_PIPE`	Provides a DBMS pipe service which enables messages to be sent between sessions.	Chapter 45
`DBMS_PROFILER`	Provides a Probe Profiler API to profile existing PL/SQL applications and identify performance bottlenecks.	Chapter 46
`DBMS_PROPAGATION_ADM`	Provides administrative procedures for configuring propagation from a source queue to a destination queue.	Chapter 47
`DBMS_RANDOM`	Provides a built-in random number generator.	Chapter 48
`DBMS_RECTIFIER_DIFF`	Provides APIs used to detect and resolve data inconsistencies between two replicated sites.	Chapter 49
`DBMS_REDEFINITION`	Lets you perform an online reorganization of tables.	Chapter 50
`DBMS_REFRESH`	Lets you create groups of snapshots that can be refreshed together to a transactionally consistent point in time. Requires the Distributed Option.	Chapter 51
`DBMS_REPAIR`	Provides data corruption repair procedures.	Chapter 52
`DBMS_REPCAT`	Provides routines to administer and update the replication catalog and environment. Requires the Replication Option.	Chapter 53
`DBMS_REPCAT_ADMIN`	Lets you create users with the privileges needed by the symmetric replication facility. Requires the Replication Option.	Chapter 54
`DBMS_REPCAT_INSTATIATE`	Instantiates deployment templates. Requires the Replication Option.	Chapter 55
`DBMS_REPCAT_RGT`	Controls the maintenance and definition of refresh group templates. Requires the Replication Option.	Chapter 56
`DBMS_REPUTIL`	Provides routines to generate shadow tables, triggers, and packages for table replication.	Chapter 57
`DBMS_RESOURCE_MANAGER`	Maintains plans, consumer groups, and plan directives; it also provides semantics so that you may group together changes to the plan schema.	Chapter 58
`DBMS_RESOURCE_MANAGER_PRIVS`	Maintains privileges associated with resource consumer groups.	Chapter 59
`DBMS_RESUMABLE`	Lets you suspend large operations that run out of space or reach space limits after executing for a long time, fix the problem, and make the statement resume execution.	Chapter 60
`DBMS_RLS`	Provides row level security administrative interface.	Chapter 61
`DBMS_ROWID`	Provides procedures to create rowids and to interpret their contents.	Chapter 62
`DBMS_RULE`	Describes the `EVALUATE` procedure used in Streams.	Chapter 63
`DBMS_RULE_ADM`	Describes the administrative interface for creating and managing rules, rule sets, and rule evaluation contexts; used in Streams.	Chapter 64
`DBMS_SESSION`	Provides access to SQL `ALTER` `SESSION` statements, and other session information, from stored procedures.	Chapter 65
`DBMS_SHARED_POOL`	Lets you keep objects in shared memory, so that they will not be aged out with the normal LRU mechanism.	Chapter 66
`DBMS_SPACE`	Provides segment space information not available through standard SQL.	Chapter 67
`DBMS_SPACE_ADMIN`	Provides tablespace and segment space administration not available through the standard SQL.	Chapter 68
`DBMS_SQL`	Lets you use dynamic SQL to access the database.	Chapter 69
`DBMS_STATS`	Provides a mechanism for users to view and modify optimizer statistics gathered for database objects.	Chapter 70
`DBMS_STORAGE_MAP`	Communicates with FMON to invoke mapping operations.	Chapter 71
`DBMS_STRM`	Describes the interface to convert `SYS.AnyData` objects into LCR objects and an interface to annotate redo entries generated by a session with a binary tag.	Chapter 72
`DBMS_STRM_A`	Describes administrative procedures for adding and removing simple rules, without transformations, for capture, propagation, and apply at the table, schema, and database level.	Chapter 73
`DBMS_TRACE`	Provides routines to start and stop PL/SQL tracing.	Chapter 74
`DBMS_TRANSACTION`	Provides access to SQL transaction statements from stored procedures and monitors transaction activities.	Chapter 75
`DBMS_TRANSFORM`	Provides an interface to the message format transformation features of Oracle Advanced Queuing.	Chapter 76
`DBMS_TTS`	Checks if the transportable set is self-contained.	Chapter 77
`DBMS_TYPES`	Consists of constants, which represent the built-in and user-defined types.	Chapter 78
`DBMS_UTILITY`	Provides various utility routines.	Chapter 79
`DBMS_WM`	Describes how to use the programming interface to Oracle Database Workspace Manager to work with long transactions.	Chapter 80
`DBMS_XDB`	Describes Resource Management and Access Control APIs for PL/SQL	Chapter 81
`DBMS_XDBT`	Describes how an administrator can create a ConText index on the XML DB hierarchy and configure it for automatic maintenance	Chapter 82
`DBMS_XDB_VERSION`	Describes versioning APIs	Chapter 83
`DBMS_XMLDOM`	Explains access to XMLType objects	Chapter 84
`DBMS_XMLGEN`	Converts the results of a SQL query to a canonical XML format.	Chapter 85
`DBMS_XMLPARSER`	Explains access to the contents and structure of XML documents.	Chapter 86
`DMBS_XMLQUERY`	Provides database-to-XMLType functionality.	Chapter 87
`DBMS_XMLSAVE`	Provides XML-to-database-type functionality.	Chapter 88
`DBMS_XMLSCHEMA`	Explains procedures to register and delete XML schemas.	Chapter 89
`DBMS_XPLAN`	Describes how to format the output of the `EXPLAIN` `PLAN` command.	Chapter 90
`DBMS_XSLPROCESSOR`	Explains access to the contents and structure of XML documents.	Chapter 91
`DEBUG_EXTPROC`	Lets you debug external procedures on platforms with debuggers that attach to a running process.	Chapter 92
`SDO_CS` `(refer to` Note #1)	Provides functions for coordinate system transformation.	Oracle Spatial User's Guide and Reference
`SDO_GEOM` `(refer to` Note #1)	Provides functions implementing geometric operations on spatial objects.	Oracle Spatial User's Guide and Reference
`SDO_LRS` `(refer to` Note #1)	Provides functions for linear referencing system support.	Oracle Spatial User's Guide and Reference
`SDO_MIGRATE` `(refer to` Note #1)	Provides functions for migrating spatial data from previous releases.	Oracle Spatial User's Guide and Reference
`SDO_TUNE` `(refer to` Note #1)	Provides functions for selecting parameters that determine the behavior of the spatial indexing scheme used in Oracle Spatial.	Oracle Spatial User's Guide and Reference
`SDO_UTIL` `(refer to` Note #1)	Provides utility functions and procedures for Oracle Spatial.	Oracle Spatial User's Guide and Reference
`UTL_COLL`	Enables PL/SQL programs to use collection locators to query and update.	Chapter 93
`UTL_ENCODE`	Provides functions that encode RAW data into a standard encoded format so that the data can be transported between hosts.	Chapter 94
`UTL_FILE`	Enables your PL/SQL programs to read and write operating system text files and provides a restricted version of standard operating system stream file I/O.	Chapter 95
`UTL_HTTP`	Enables HTTP callouts from PL/SQL and SQL to access data on the Internet or to call Oracle Web Server Cartridges.	Chapter 96
`UTL_INADDR`	Provides a procedure to support internet addressing.	Chapter 97
`UTL_PG`	Provides functions for converting COBOL numeric data into Oracle numbers and Oracle numbers into COBOL numeric data.	Oracle Procedural Gateway for APPC User's Guide
`UTL_RAW`	Provides SQL functions for `RAW` datatypes that concat, substr to and from `RAWS.`	Chapter 98
`UTL_REF`	Enables a PL/SQL program to access an object by providing a reference to the object.	Chapter 99
`UTL_SMTP`	Provides PL/SQL functionality to send emails.	Chapter 100
`UTL_TCP`	Provides PL/SQL functionality to support simple TCP/IP-based communications between servers and the outside world.	Chapter 101
`UTL_URL`	Provides escape and unescape mechanisms for URL characters.	Chapter 102
`ANYDATA TYPE`	A self-describing data instance type containing an instance of the type plus a description	Chapter 103
`ANYDATASET TYPE`	Contains a description of a given type plus a set of data instances of that type	Chapter 104
`ANYTYPE TYPE`	Contains a type description of any persistent SQL type, named or unnamed, including object types and collection types; or, it can be used to construct new transient type descriptions	Chapter 105
`JMS TYPES`	Describes JMS types so that a PL/SQL application can use JMS queues of JMS types	Chapter 107
`ADVANCED QUEUING TYPES`	Describes the types used in Advanced Queuing	Chapter 106
`LOGICAL CHANGE RECORD TYPES`	Describes LCR types, which are message payloads that contain information about changes to a database, used in Streams	Chapter 108
`RULES TYPES`	Describes the types used with rules, rule sets, and evaluation contexts	Chapter 109
Note #1 Spatial packages are installed in user MDSYS with public synonyms.

Summary of Subprograms in Supplemental Packages

The packages listed in this section are documented in other Oracle books. See Table 1-1 for the documentation reference for each package. See Table 1-2 through Table 1-8 for the subprograms provided with these packages.

SDO_CS Package

Table 1-2 SDO_CS Package Subprograms

Subprogram	Description
`SDO_CS.TRANSFORM`	Transforms a geometry representation using a coordinate system (specified by SRID or name).
`SDO_CS.TRANSFORM_LAYER`	Transforms an entire layer of geometries (that is, all geometries in a specified column in a table).
`VIEWPORT_TRANSFORM`	Transforms an optimized rectangle into a valid geodetic polygon for use with Spatial operators and functions.

SDO_GEOM Package

Table 1-3 SDO_GEOM Package Subprograms

Subprogram	Description
`RELATE`	Determines how two objects interact.
`SDO_ARC_DENSIFY`	Changes each circular arc into an approximation consisting of straight lines, and each circle into a polygon consisting of a series of straight lines that approximate the circle.
`SDO_AREA`	Computes the area of a two-dimensional polygon.
`SDO_BUFFER`	Generates a buffer polygon around a geometry.
`SDO_CENTROID`	Returns the centroid of a polygon.
`SDO_CONVEXHULL`	Returns a polygon-type object that represents the convex hull of a geometry object.
`SDO_DIFFERENCE`	Returns a geometry object that is the topological difference (MINUS operation) of two geometry objects.
`SDO_DISTANCE`	Computes the distance between two geometry objects.
`SDO_INTERSECTION`	Returns a geometry object that is the topological intersection (AND operation) of two geometry objects.
`SDO_LENGTH`	Computes the length or perimeter of a geometry.
`SDO_MAX_MBR_ORDINATE`	Returns the maximum value for the specified ordinate of the minimum bounding rectangle of a geometry object.
`SDO_MBR`	Returns the minimum bounding rectangle of a geometry.
`SDO_MIN_MBR_ORDINATE`	Returns the minimum value for the specified ordinate of the minimum bounding rectangle of a geometry object.
`SDO_POINTONSURFACE`	Returns a point that is guaranteed to be on the surface of a polygon.
`SDO_UNION`	Returns a geometry object that is the topological union (OR operation) of two geometry objects.
`SDO_XOR`	Returns a geometry object that is the topological symmetric difference (XOR operation) of two geometry objects.
`VALIDATE_GEOMETRY`	Determines if a geometry is valid.
`VALIDATE_GEOMETRY_WITH_CONTEXT`	Performs a consistency check for valid geometry types and returns context information if the geometry is invalid. The function checks the representation of the geometry from the tables against the element definitions.
`VALIDATE_LAYER`	Determines if all the geometries stored in a column are valid.
`VALIDATE_LAYER`_WITH_CONTEXT	Examines a geometry column to determine if the stored geometries follow the defined rules for geometry objects, and returns context information about any invalid geometries.
`WITHIN_DISTANCE`	Determines if two geometries are within a specified Euclidean distance from one another.

SDO_LRS Package

Table 1-4 SDO_LRS Package Subprograms

Subprogram	Description
`CLIP_GEOM_SEGMENT`	Clips a geometric segment (synonym of DYNAMIC_SEGMENT).
`CONCATENATE_GEOM_SEGMENTS`	Concatenates two geometric segments into one segment.
`CONNECTED_GEOM_SEGMENTS`	Checks if two geometric segments are connected.
`CONVERT_TO_LRS_DIM_ARRAY`	Converts a standard dimensional array to a Linear Referencing System dimensional array by creating a measure dimension.
`CONVERT_TO_LRS_GEOM`	Converts a standard SDO_GEOMETRY line string to a Linear Referencing System geometric segment by adding measure information.
`CONVERT_TO_LRS_LAYER`	Converts all geometry objects in a column of type SDO_GEOMETRY from standard line string geometries without measure information to Linear Referencing System geometric segments with measure information, and updates the metadata.
`CONVERT_TO_STD_DIM_ARRAY`	Converts a Linear Referencing System dimensional array to a standard dimensional array by removing the measure dimension.
`CONVERT_TO_STD_GEOM`	Converts a Linear Referencing System geometric segment to a standard SDO_GEOMETRY line string by removing measure information.
`CONVERT_TO_STD_LAYER`	Converts all geometry objects in a column of type SDO_GEOMETRY from Linear Referencing System geometric segments with measure information to standard line string geometries without measure information, and updates the metadata.
`DEFINE_GEOM_SEGMENT`	Defines a geometric segment.
`DYNAMIC_SEGMENT`	Clips a geometric segment (synonym of CLIP_GEOM_SEGMENT).
`FIND_LRS_DIM_POS`	Returns the position of the measure dimension within the `SDO_DIM_ARRAY` structure for a specified `SDO_GEOMETRY` column.
`FIND_MEASURE`	Returns the measure of the closest point on a segment to a specified projection point.
`GEOM_SEGMENT_END_MEASURE`	Returns the end measure of a geometric segment.
`GEOM_SEGMENT_END_PT`	Returns the end point of a geometric segment.
`GEOM_SEGMENT_LENGTH`	Returns the length of a geometric segment.
`GEOM_SEGMENT_START_MEASURE`	Returns the start measure of a geometric segment.
`GEOM_SEGMENT_START_PT`	Returns the start point of a geometric segment.
`GET_MEASURE`	Returns the measure of an LRS point.
`IS_GEOM_SEGMENT_DEFINED`	Checks if an LRS segment is defined correctly.
`IS_MEASURE_DECREASING`	Checks if the measure values along an LRS segment are decreasing (that is, descending in numerical value).
`IS_MEASURE_INCREASING`	Checks if the measure values along an LRS segment are increasing (that is, ascending in numerical value).
`LOCATE_PT`	Returns the point located at a specified distance from the start of a geometric segment.
`MEASURE_RANGE`	Returns the measure range of a geometric segment, that is, the difference between the start measure and end measure.
`MEASURE_TO_PERCENTAGE`	Returns the percentage (0 to 100) that a specified measure is of the measure range of a geometric segment.
`OFFSET_GEOM_SEGMENT`	Returns the geometric segment at a specified offset from a geometric segment.
`PERCENTAGE_TO_MEASURE`	Returns the measure value of a specified percentage (0 to 100) of the measure range of a geometric segment.
`PROJECT_PT`	Returns the projection point of a point on a geometric segment.
`REDEFINE_GEOM_SEGMENT`	Populates the measures of all shape points of a geometric segment based on the start and end measures, overriding any previously assigned measures between the start point and end point.
`RESET_MEASURE`	Sets all measures of a geometric segment, including the start and end measures, to null values, overriding any previously assigned measures.
`REVERSE_GEOMETRY`	Returns a new geometric segment by reversing the measure values and the direction of the original geometric segment.
`REVERSE_MEASURE`	Returns a new geometric segment by reversing the original geometric segment.
`SCALE_GEOM_SEGMENT`	Scales a geometric segment.
`SET_PT_MEASURE`	Sets the measure value of a specified point.
`SPLIT_GEOM_SEGMENT`	Splits a geometric segment into two segments.
`TRANSLATE_MEASURE`	Returns a new geometric segment by translating the original geometric segment (that is, shifting the start and end measures by a specified value).
`VALID_GEOM_SEGMENT`	Checks if a geometric segment is valid.
`VALID_LRS_PT`	Checks if an LRS point is valid.
`VALID_MEASURE`	Checks if a measure falls within the measure range of a geometric segment.
`VALIDATE_LRS_GEOMETRY`	Checks if an LRS geometry is valid.

SDO_MIGRATE Package

Table 1-5 SDO_MIGRATE Package Subprograms

Procedure	Description
`FROM_815_TO_81X`	Migrates data from Spatial release 8.1.5 to the current release.
`OGIS_METADATA_FROM`	Generates a temporary table used when migrating OGIS (OpenGIS) metadata tables.
`OGIS_METADATA_TO`	Reads a temporary table used when migrating OGIS metadata tables.
`TO_734`	Migrates data from a previous release of Spatial Data Option to release 7.3.4.
`TO_81X`	Migrates tables from Spatial Data Option 7.3.4 or Spatial Cartridge 8.0.4 to Oracle Spatial.
`TO_CURRENT`	Migrates data from a previous Spatial release to the current release.

SDO_TUNE Package

Table 1-6 SDO_TUNE Package Subprograms

Subprogram	Description
`ANALYZE_RTREE`	Analyzes an R-tree index; generates statistics about the index use, and recommends a rebuild of the index if a rebuild would improve query performance significantly.
`AVERAGE_MBR`	Calculates the average minimum bounding rectangle for geometries in a layer.
`ESTIMATE_INDEX_PERFORMANCE`	Estimates the spatial index selectivity.
`ESTIMATE_TILING_LEVEL`	Determines an appropriate tiling level for creating fixed-size index tiles.
`ESTIMATE_TILING_TIME`	Estimates the tiling time for a layer, in seconds.
`ESTIMATE_TOTAL_NUMTILES`	Estimates the total number of spatial tiles for a layer.
`EXTENT_OF`	Determines the minimum bounding rectangle of the data in a layer.
`HISTOGRAM_ANALYSIS`	Calculates statistical histograms for a spatial layer.
`MIX_INFO`	Calculates geometry type information for a spatial layer, such as the percentage of each geometry type.
`QUALITY_DEGRADATION`	Returns the quality degradation for an R-tree index or the average quality degradation for all index tables for an R-tree index.
`RTREE_QUALITY`	Returns the quality score for an R-tree index or the average quality score for all index tables for an R-tree index.

SDO_UTIL Package

Table 1-7 SDO_UTIL Package Subprograms

Subprogram	Description
`EXTRACT`	Returns the geometry that represents a specified element (and optionally a ring) of the input geometry.
`GETVERTICES`	Returns a table containing the coordinates of the vertices of the input geometry.

UTL_PG Package

Table 1-8 UTL_PG Package Subprograms

Subprogram	Description
`MAKE_NUMBER_TO_RAW_FORMAT`	Makes a `number_to_raw` format conversion specification used to convert an Oracle number of declared precision and scale to a `RAW` byte-string in the remote host internal format.
`MAKE_RAW_TO_NUMBER_FORMAT`	Makes a `raw_to_number` format conversion specification used to convert a `RAW` byte-string from the remote host internal format into an Oracle number of comparable precision and scale.
`NUMBER_TO_RAW`	Converts an Oracle number of declared precision and scale to a `RAW` byte-string in the remote host internal format.
`NUMBER_TO_RAW_ FORMAT`	Converts, according to the `number_to_raw` conversion format n2rfmt, an Oracle number numval of declared precision and scale to a `RAW` byte-string in the remote host internal format.
`RAW_TO_NUMBER`	Converts a `RAW` byte-string from the remote host internal format into an Oracle number.
`RAW_TO_NUMBER_ FORMAT`	Converts, according to the `raw_to_number` conversion format `r2nfmt`, a `RAW` byte-string `rawval` in the remote host internal format to an Oracle number.
`WMSG`	Extracts a warning message specified by `wmsgitem` from `wmsgblk`.
`WMSGCNT`	Tests a `wmsgblk` to determine how many warnings, if any, are present.