span8
span4
span8
span4
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
To start,are you able to view the geometry of what is coded in binary?Then we can figure out writing to Oracle...
geometry replacer with encoded polyline yields a result,using your sample.
Other settings yield error.
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
Null values in Oracle GEOM column6 Answers
Moving Geomedia Text Features from one Oracle table to another3 Answers
Why won't FME write to my Oracle 11g Express Edition database?4 Answers
Getting Various 10.6.1 SDE/Oracle errors on truncate/reload0 Answers
How can I Force Upper Case attribute names when writing to Oracle DB in FME 2016?2 Answers
© 2019 亚搏在线Safe Software Inc |法律