2 Replies Latest reply: Jul 22, 2014 7:43 AM by Luigi Cardeles RSS

    Convert DD to DMS using sdo_coord_ops = 101 returns ORA-13199

    Luigi Cardeles



      I need to convert lat/long DD to DMS.

      There is an operation in sdo_coord_ops (coord_op_id = 101) to do that but returns ORA-13199 when i try sdo_cs.add_preference_for_op



      I know that i can do that conversion with a function (Re: SDO_UTIL.BEARING_TILT_FOR_POINTS in a Select statement - thanks Simon!).


      How i know which operation that exists in sdo_coord_ops are actually implemented or not?