SQL> update b$gc_cbl_t_temp a set A.G3E_GEOMETRY.sdo_elem_info = sdo_elem_info_a
rray(1,1,1,4,1,0),
  2  A.G3E_GEOMETRY.sdo_ordinates(1) = A.G3E_GEOMETRY.SDO_POINT.X,
  3  A.G3E_GEOMETRY.sdo_ordinates(2) = A.G3E_GEOMETRY.SDO_POINT.Y,
  4  A.G3E_GEOMETRY.sdo_ordinates(3) = 0,
  5  A.G3E_GEOMETRY.sdo_ordinates(4) = COS(ORIENTATION_TEMP),
  6  A.G3E_GEOMETRY.sdo_ordinates(5) = SIN(ORIENTATION_TEMP),
  7  A.G3E_GEOMETRY.sdo_ordinates(6) = 0,
  8  A.G3E_GEOMETRY.SDO_POINT = NULL ;
A.G3E_GEOMETRY.sdo_ordinates(1) = A.G3E_GEOMETRY.SDO_POINT.X,
                            *
ERROR at line 2:
ORA-00927: missing equal sign

update b$gc_cbl_t_temp a 
set    A.G3E_GEOMETRY.sdo_elem_info = sdo_elem_info_array(1,1,1,4,1,0),
       A.G3E_GEOMETRY.sdo_ordinates = 
         sdo_ordinate_array 
           (A.G3E_GEOMETRY.SDO_POINT.X,
            A.G3E_GEOMETRY.SDO_POINT.Y,
            0,
            COS(ORIENTATION_TEMP),
            SIN(ORIENTATION_TEMP),
            0), 
       A.G3E_GEOMETRY.SDO_POINT = NULL;