This discussion is archived
0 Replies Latest reply: Nov 9, 2012 7:15 AM by 973504 RSS

change transformation plan

973504 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points