Spatial object information

[amolp76]

Hi,

I am using oracle Spatial data cartiridge. Oracle Spatial uses MDSYS.SDO_GEOMETRY objects.

The definition of this object is
SDO_GTYPE NUMBER
SDO_SRID NUMBER
SDO_POINT SDO_POINT_TYPE
SDO_ELEM_INFO SDO_ELEM_INFO_ARRAY
SDO_ORDINATES SDO_ORDINATE_ARRAY

When I try to select this object in TOracleDataset, I can directly access SDO_GTYPE, SDO_SRID and SDO_POINT but cannot access objects SDO_ELEM_INFO and SDO_ORDINATES. Their definition in database is of type VARRAY. Will it be possible in some way to access these varrays directly in queries in form of array of variants or number ??

Regards,
Amol.

These defination of this object is VARRAY(1048576) OF NUMBER

is it possible to have some extra support for this object type.

 

[Marco Kalter]

For a varray column or attribute you will have to setup a detail dataset. At design time the automatic master/detail setup functionality will create the appropriate SQL and variables for the detail dataset.

------------------
Marco Kalter
Allround Automations