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
Folks, I posted another earlier discussion on this topic over the weekend, but since I got my iPhone on Friday, I have probably burned about 20 hours working trying to figure out why I cannot sync my calendar and contacts from Office 2003 "OR" 2 [More]
Hello! I have a js function defined in 'HTML Header' : <script language="JavaScript" type="text/javascript"> function disp_alert() alert("Data is invalid! Correct the data and click CONFIRM again.") </script> I al [More]
Hey, I have a question about the SAP BC. What are the steps I have to do, to use the BC with a Java program? My task is to create a program which downloads material master datas from SAP. I just installed the BC, and hope, that I did it correctly Man [More]
It just cant find it! Seriously! Take a look http://img707.imageshack.us/i/24375953.png/ What to do?Does iPhoto import the photos anyway? The Import All button is available.Read other 2 answers [More]
can any one send some frequent failures and errors.with sol if possible.Prasanth Check these weblogs. Hope these helps. Thnaks Sat /people/siegfried.szameitat/blog/2005/07/28/data-load-errors--basic-checks Re: dataloading problems from r/3 ?Read othe [More]
Hi experts, should i ignore the clearing documents (net=0) in Cashflow Analysis. For example follwing movements are available for cash flow relevante Bank account  offene posten 50 offene posten -30   clearing doc 20   clearing doc -20 Which one is c [More]
Hello All, I am transferring stock from 1000 plant to 1100 plant. At the time of the procurement in the Plant 1000 the WBS mentioned is A and the GR in the stock is done with the account assignment Q with the WBS and the inventory created after the G [More]
Hi guys, I have developed one Z report which when I execute it generates a letter in notepad giving the information about balance confirmations. But now the requirement is that when i execute the report it shud genearte the letter and send mails to o [More]
Hi All , Oracle Version:11.2.0.3 I need one help for one issue with ASM disk addition. It is a two node RAC and one disk group was filled. One disk was available as UNUSED001 and so we renamed it ran scan disk  and added the disk to the diskgroup on [More]
i just got a ipod touch today to replace my old nano, everything is fine except that one of my playlist does not apear to be working right. i made a smart playlist for the 50 most played and none of the songs that are on that playlist on itunes sync [More]