updating sdo_ordinate array

[Robert Morrison]

Title: newocp Stationery

Hi,   a query for all the spatial experts out there.   My ordinate array has values stored in metres, ie   SDO_GEOMETRY(3, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 3, 1), SDO_ORDINATE_ARRAY(100066.781, 203070.305, 100574.094, 202339.257, 100170.282, 200904.413)   I need them stored in mm, ie   SDO_GEOMETRY(3, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 3, 1), SDO_ORDINATE_ARRAY(100066781, 203070305, 100574094, 202339257, 100170282, 200904413)   I have tried the following, however although it executes ok it doesn't actually update anything.   DECLARE i number; BEGIN FOR rec IN (SELECT area FROM sdo_test) LOOP i := 1; while i < rec.area.sdo_ordinates.count LOOP rec.area.sdo_ordinates(i):=(rec.area.sdo_ordinates(i) * 1000); i := i + 1; end loop; END LOOP; commit; END; / Can anyone point me in the right direction.   TIA   Robert Morrison