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
I know this is going to sound like a stupid question but this is all new to me so please bear with me I just bought an iPod video, a World Travel Adapter kit and the Power Duo kit - which contains a power block wall charger, USB mini cable, and car c [More]
<%=String X=(String)session.getAttribute(y)%> How do we get X into a cm:select tag? I attempting to do a query and want to pass X into it. Tried doing <%=X%> and it's causing a JSP compile error. So, I guess I need to know how to pass a sessio [More]
Every time I use my internal speakers (especially on high voice), my speakers' strength seems to lessen after few seconds of sound. But after about 30 minutes or so, the speakers are back to normal, but the same conflict repeats again after using the [More]
Hello, I'm having this problem. Mail is not downloading messages from two accounts. I don't know why but there're two accounts working so bad. If I click with the right button on the account and click to see the account details, I can see the message [More]
Hi, im using a Century Optics 16:9 adaptor. My question is would i edit it using a 16:9 preset or should i use a 16:9 preset in FCE. I started using a 16:9 preset vor importing and exporting but one of the problems i get is that when i adjust a seque [More]
I have around 25000 images in my A3 library. I'd say about 50% of them are raw. They are referenced on an external 1TB MyBook studio connected by FW800. Aperture is dying. If I so much as scroll one line of photos it just hangs for ages and is comple [More]
Hi all I have set approval for purchase oder , my problem is that when i create a purchase order using purchase order form it is going for the approval but when i created through code it is not going for the approval . Any solution for this. Thanks i [More]
Hello, Hello I have a scenarios. One plant is selling a part to other plant at a margin. Both plants belongs to the same legal entity. How can I map this scenario in SAP? What will be the cost of my part in these two plants? What mechanism I would us [More]
this happenned about 6 months ago to us as well with an update. and archive and install solved it that time. i tried it again this time - nada tried disc utilities, repair - nada - clean bill of health. I verified permissions, but did not hit repair [More]
I have Adobe Reader XI and when I scan a document and need to convert it to PDF it has a box that says paid account yet when I click to convert it wants me to buy a package. So you have to pay for a PDF converter is that right?Hi again, There isn't a [More]