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

Last updated on MAY 18, 2010

Applies to:

Oracle Spatial - Version: 11.2.0.1.0 and later   [Release: and later ]
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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms