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
Hi We have setup Crystal Enterprise V10 to SAP Authentication and we are able to connect to Crystal eportfolio with SSO from EP6SP2 app integrator based iview without any problem, by giving R/3 userid, password via usermapping. We have loaded verify. [More]
I have an iPad Air and I take lots of pictures. I installed iOS 8 last night. I don't like the lack of a Photo Stream and a Camera Roll, but I am willing to try new things, so I decided to clear out all the images from my iPad and start from scratch. [More]
Hi! I'm trying to create a workflow which would basically create a new website project folder structure with a single click. I have an htdocs folder in which I'd like to create a new project folder with a number of subfolders. htdocs --prj1 --prj2 -- [More]
It won't load video, and the play buttons are missing.I think I found a solution. Try deleting the cache and restart firefox, that worked for me.Read other 3 answers [More]
How to call SQL Scripts in DBMS_SCHEDULER? Things I got working 1) Successfully created and tested a PL/SQL that was created under SQL Workshop->SQL Scripts (I named it 'TEST'). I was able to run this no problem. 2) Successfully created a DBMS_SCHEDU [More]
Hi, We have a swing application in which we use tab key to navigate input fields. The problem is that on some machines the tab key does not do anything where on some it works perfectly. Could it be a JRE version or any other issue? (OS is Windows 200 [More]
Hi, I have a multi source universe on SQL Server and BW, the query against SQL Server times out exactly after 10 mins, the time out setting in the universe connection and database have been bumped to 30 min but my query still times out after 10 mins, [More]
Hi Forum, I am facing one problem since last two week that SAP HANG on on Server and client. We are using Windows 2003 R2 server and Windows XP as client. For Remote conneciton we are using GoGlobal. SAP Business One 2005 B PL 25 we are using. Addon [More]
Hi All, I am constructing Posture conditions in ISE, which check  Windows Update are not more than 7 days old. Can you guys help me in formulating this condition. Thanking in advance, Thank You, AdityaHello Aditya, Configure WSUS Remediation This exa [More]
Hi My project needs attachment funtionality with the follow-up activity (Transaction type -Tasks) with the business role IC_AGENT. I see attachments with Tasks in the business role IC_MANAGER. How do you suggest to take advantage of this IC_MANAGER f [More]