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

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

    hazar82

      Hi,

       

      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?

       

      Thanks!