0 Replies Latest reply: Nov 9, 2012 9:15 AM by 973504 RSS

    change transformation plan

    973504
      Hello,

      when i try to change the transformation like following, i get an error message.
      How can i change the Transformation Plan/method if there are defined multiple OperationID entries in SDO_COORD_OPS for the SRC_SRID and Target_SRID combination?

      My Code:
      SDO_CS.create_pref_concatenated_op(
      3000,
      'CONCATENATED_OPERATION_3000',
      TFM_PLAN(SDO_TFM_CHAIN(4258,1309, 4314)),
      null );
      Result:
      ORA-00001: unique constraint (MDSYS.PREFERRED_OPS_SYS_PRIM) violated
      ORA-06512: at "MDSYS.SDO_CS", line 1858
      ORA-06512: at "MDSYS.SDO_CS", line 1754

      Using
      SDO_CS.REVOKE_PREFERENCE_FOR_OP(1309,4258,4314,null);
      Results in
      ORA-00001: unique constraint (MDSYS.PREFERRED_OPS_SYS_PRIM) violated
      ORA-06512: at "MDSYS.SDO_CS", line 1858
      ORA-06512: at line 1

      with kind regards

      Martin