Sitemap

Amicuk Programming Answers

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

-0001-11-30   Views:0

Advertisement

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_T

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!

The replay answer
Advertisement
Well, if you check the documentation it's quite clear: Coordinate Systems (Spatial Reference Systems)
Of course you could also run something like this:
select co.coord_op_id,
       co.coord_op_name,
       com.coord_op_method_name,
       com.is_implemented_forward,
       com.is_implemented_reverse
from sdo_coord_ops co,
     sdo_coord_op_methods com
where co.coord_op_id = 101 and
      com.coord_op_method_id = co.coord_op_method_id;
0 = not implemented, 1 = implemented.

Go to See the other 3 answers

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

Category:DefaultRelease time:-0001-11-30Views:130

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_T[More]

SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT returns ORA-13199 SRID does not exist

Category:DefaultRelease time:-0001-11-30Views:130

Hi everyone, I'm facing with this error while I was trying to list wrong spatial data (11.0.2.0.3 RAC (AIX)) Select   * From     table Where    SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT (GEOMETRY,0.001)! ='TRUE' It returns : ORA-13199: SRID does not ex[More]

Oracle query on dblinked SQL Server tables returns ORA-00904 error

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have created a dblink to a SQL Server database from Oracle using Generic Connectivity. The following query returns ORA-00904 Invalid Identifier error in the WHERE clause (tblEmp.Empno) SELECT "EmpNo","EmpName", "DeptName&quo[More]

A In-line view query works with 8.1.6 but returns ORA-1008 with 8.1.7

Category:DefaultRelease time:-0001-11-30Views:130

Hello Gurus, The following query works fine with 8.1.6 but returns ORA-1008: not all variables bound with 8.1.7. Here is the query: SELECT y.node_id , y.parent_node_id FROM ( SELECT x.node_id ,x.parent_node_id FROM ( SELECT a.node_id ,a.parent_node_i[More]

OCITransCommit() returns ORA-01013 for correctly committed transaction

Category:DefaultRelease time:-0001-11-30Views:130

I had the following issue which seems to me a critial bug in Oracle 11g: Breaking an oracle transaction asynchronously with OCIBreak() while transaction is being committed with OCITransCommit() did result in a correctly committed transaction on the d[More]

Bulk table update returning ORA-00001: unique constraint

Category:DefaultRelease time:-0001-11-30Views:130

I'm trying to update every record in a PROPERTY table that has a CLASS of either 1 or 9 and a STATUS of 'LHLD'. CLASS and STATUS descriptor records are in different tables to the PROPERTY table but reference the PROPERTY records by the PROPERTY table[More]

How to convert Smart Form into PDF format and return the result in BAPI?

Category:DefaultRelease time:2015-10-11Views:130

I want to convert a Smart Form into PDF format and return the result in BAPI. can anyone tell me how it can be done with related example regards pranayhi, smart form to pdf-- All you have to do is call your SF to get OTF and then concert it to PDF. W[More]

Converting Frame files to PDF adds carriage return in code snippets

Category:DefaultRelease time:2015-10-11Views:130

Our writing group is using FrameMaker 7.2 with Acrobat 9. The documentation we write includes code snippets. Conversion from Frame to PDF adds a carriage return to the end of any line of code. This causes any snippet containing a wrapped line to be i[More]

How do I convert the single x and y coordinates returned by a CWGraph Click event to the Cursor X and Y Positions?

Category:DefaultRelease time:2015-10-11Views:130

I am trying a work around for another problem. cwCSnapNearestPoint does not give me a CursorDown event (TrackMode = cwGTrackDragCursor). I need to know when the user has clicked on a Cursor. I need to figure out when the user has clicked on a cursor.[More]

Forms application returns "ORA-01403 no data found" exception on Windows 7

Category:DefaultRelease time:2015-10-11Views:130

Hi everyone, I am currently involved in an application compatibility project for an O/S migration from Windows XP to Windows 7. We have a legacy Oracle Dev6i P18 Forms application that has been working perfectly on Windows XP for the last decade or s[More]

PLSQL function body returning an sql report returns ORA-01403 No Data Found

Category:DefaultRelease time:2015-10-11Views:130

I am on APEX 3.1.2.00.02 and Oracle 10g. I am developing a report with SQL Query (PL/SQL function body returning SQL query) type. But on running the report I am getting report error: ORA-01403: no data found Region Source declare   qry varchar2(32767[More]

Hot
Despite what has appeared in various blogs around the web (and what I had been told previously), it looks like a Mini-DisplayPort to HDMI adapter from Monoprice will not be arriving this month. An e-mail message from monoprice tech support states: "W [More]
hi i need the code for sales document report for all open documents is sd ...      can anyone help me out.                                  thanks in advanceTry transaction VA05. In that choose "Open Orders" along with other selection criteria. [More]
I am new to Java and installed MySql and also installed mysql-connectorJ driver. I can compile the code below, but when I go to run it, I get "Exception in thread "main" java.lang.NoClassDefFoundError: JDBCDemo/class" error. I can't fi [More]
I want to download new music onto my iphone, but it will not let me. I have been doing it for the past year on my old desktop computer but recently brought a laptop and got rid of that. When i try to now sinc the music to my phone it is telling me my [More]
How can I allow a customer to upload an image to be stuck onto a mug or t-shirt and then view what it would look like on that mug or t-shirt?In the absence of drivers, a rather nasty way to achieve this would be to ensure that your software always oc [More]
Hi to all, I am experiencing some VERY STRANGE behaviour in JDeveloper ADFBC. I am using Jdeveloper 10.1.3.1.0.3984 to build an application using ADF and Business Components. I have four tables, JAAS_USERS, JAAS_ROLES, JAAS_REALMS and JAAS_MAPPINGS. [More]
I need to export a sequence from FCP6 and then convert that to WMV file...WHAT DO IT NEED TO DO...Does anyone know a workflow that I can follow to sort out this problem...The free version of Flip4Mac has functioning import/export capability in trial [More]
Hello Today in my company we are in SAP R3 4.7 and we have a problem that the module MSD don't have conection with modulo MM, for example, today we can't control the material in MSD. We will planning upgrade for ECC 6.0 and I want know if the problem [More]
How the heck do I deskew a PDF?  I was sent a scanned document that needs to be straightened.  Can't Adobe Acrobat 10 do this?In the tools panel, Document Processing>Optimize Scanned PDF has that option,Read other 2 answers [More]
I'm getting the following error when I try to change the Backup Settings on a new stand-alone install of 11.2.0.3.0 on Linux 5.7. Connection to host as user oracle failed. ERROR. NMO not setuid-root (Unix-only) I am NOT performing a Grid install and [More]