geometry_text_string cannot be converted correctly

Hi @whq10whq10, If you are not doing any data transformation and reading and writing from Oracle, I would try to generate a workspace (CTRL+G) using the dynamic setting. That will result if a workspace where the writer schema originates from the reader.

Hope this helps.

Thanks Itay. Actually, my case will do some data transformation from the source to the target. I tested with dynamic schema you suggested but FME complains Cannot create table within when logged in user is ''". I noticed if there is no format characters in the geometry_text_string, the transformation will be good, but if there is any format characters in geometry_text_string, FME will remove all the format characters so the geometry data is a little bit different with the original, which was not I want. I just want to keep the format characters in the target geometry, but failed after attempting to use all kinds of character, text, or string transformers.

U want to copy the sdo_geometry string to a spatial database?

Update or insert statement as explained in the oracle sdo user guide docs.

Or just push the geometry in..

You can use a sql creator to simply do read the geometry :

select

MDSYS.SDO_GEOMETRY(2001,

If you have it in a attribute

select

@Value(MySDO_attr)

from dual

etc.

and then write the output to database as desired.