My Oracle Support Banner

MDSYS.VERTEX_TYPE Definition In 11gR2 Differs Between Documentation And SQL*Plus Describe (Doc ID 1103763.1)

Last updated on FEBRUARY 11, 2019

Applies to:

Oracle Spatial and Graph - Version 11.2.0.1.0 to 11.2.0.4
Information in this document applies to any platform.

Symptoms

From the section titled "SDO_UTIL.GETVERTICES" in Chapter 32 "SDO_UTIL Package (Utility)" of the "Oracle� Spatial Developer's Guide 11g Release 2 (11.2)" manual:
( http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11830/sdo_util.htm#SPATL1237 )


"...
Usage Notes

This function returns an object of VERTEX_SET_TYPE, which consists of a table of objects of VERTEX_TYPE. Oracle Spatial defines the type VERTEX_SET_TYPE as:

CREATE TYPE vertex_set_type as TABLE OF vertex_type;

Oracle Spatial defines the object type VERTEX_TYPE as:

CREATE TYPE vertex_type AS OBJECT
(x NUMBER,
y NUMBER,
z NUMBER,
w NUMBER,
id NUMBER);
..."



However, a describe of the MDSYS.VERTEX_TYPE via SQL*Plus shows a different definition in 11.2.0.1.0:



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.