Hi all the data in the column looks like its in a binary format but everything i try fails, please help. Here is an example of a record. 30303130010000000700000075B5157B9CB80F4187EB51B8CEEA08414282E24755B90F41EE51B81ED9EA0841D36F5F477DB90F41EE51B81ED9EA084132772DE1C6B90F41808CB9EBD9EA084132772DE1C6B90F41F6FDD4B882EA0841E27A14AE9BB80F41AB13D0847FEA084175B5157B9CB80F4187EB51B8CEEA08410000000000
Question
How do i extract geometry saves to a long raw column in oracle?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Is this Oracle spatial? If so, you can use the built-in function TO_WKTGEOMETRY() to convert the geometry to e.g. WKT:
select SDO_UTIL.TO_WKTGEOMETRY(shape) from my_table;More info in the Oracle docs: https://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_util.htm#SPATL180
Is this Oracle spatial? If so, you can use the built-in function TO_WKTGEOMETRY() to convert the geometry to e.g. WKT:
select SDO_UTIL.TO_WKTGEOMETRY(shape) from my_table;More info in the Oracle docs: https://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_util.htm#SPATL180
I'm not sure if its oracle spatial, its an old proprietary system which has no documentation. I tried your sql and get an error, "illegal use of LONG datatype".
+15- Contributor
geometry replacer with encoded polyline yields a result, using your sample.
Other settings yield error.
+1To start, are you able to view the geometry of what is coded in binary? Then we can figure out writing to Oracle...
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.