Hello,

maybe I'm lucky to find here any Oracle Spatial experts.

I would like to know if it is possible to create SDO_GEOMETRY objects
by reading the coordinates out of simple number attributes for
latitude and longitude using a simple sql script.

e.g. Point object:

The GEOM field is of type SDO_GEOMETRY and should be initialized by
reading the coordinates out of the NUMBER field LAT and LON:

ID LAT LON GEOM
1 47 12 null

GEOM should be initialized with the object value:

SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(47, 11, NULL), NULL, NULL)

Regards,
Norbert