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:

SQL> desc mdsys.vertex_type
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 X                                                  NUMBER
 Y                                                  NUMBER
 Z                                                  NUMBER
 W                                                  NUMBER
 V5                                                 NUMBER
 V6                                                 NUMBER
 V7                                                 NUMBER
 V8                                                 NUMBER
 V9                                                 NUMBER
 V10                                                NUMBER
 V11                                                NUMBER
 ID                                                 NUMBER



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.