Hi

Have a look at this topic from yesterday, the same applies here: https://knowledge.safe.com/questions/23123/shape-column-is-not-showing-from-oracle-spatial-ta.html

In short, what you're describing is normal. Try connecting an Inspector transformer to your reader and run the workspace. The geometries should be visible in the Inspector window.

And yes, the Oracle Spatial Object is most likely the correct reader, unless your Oracle instance is very (very) old.

David

Hi David,

thanks alot for the quick reply, but i do have some more questions on this.

I have to perform some operations on the Coordinates column if it doesn't show in work space then how to perform the operations on it internally and also i want that column in my output csv file as well, how to achieve this?

and also as you said , i have connected to Inspector transformation but i am not able to see the coordinates column. can you please help me,

Many Thanks in Advance.

try CoordinateExtractor (gives you _x,_y and _z attributes)

Hi @kiranmaiinfosys

If "Coordinates" is the name of the geometry column, then you don't need to see it in FME Workbench. A feature in FME is made up of geometry and attributes. You'll see the attributes but the geometry is sort of assumed. But there are lots of transformers that will operate on that geometry, even if you don't see the column name.

I hope that helps. If you need more assistance, please feel free to contact our support team (safe.com/support) and ask for an online meeting/demo if you need us to cover any particular pieces of functionality,

Regards

Mark

Mark Ireland

Product Evangelist

Safe Software Inc.