Skip to main content
Question

I am trying to read/query in USER_TAB_COLUMNS from oracle database

  • August 30, 2018
  • 3 replies
  • 74 views
J
Forum|alt.badge.img

My goal is to get schema attributes to save to a csv file that I can then use to setup my feature writer user attributes. I am struggling to get anything to work.

Every sql I try returns errors, I have tried sql creator and sql executor with no success.

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.

3 replies

J
Forum|alt.badge.img
  • jacq
  • Author
  • August 31, 2018

I have my sql working now, I have created my csv file

Now I am struggling to get my writer to work

I have added the csv as a workspace resource using 'schema from table'

J
Forum|alt.badge.img
  • jacq
  • Author
  • August 31, 2018

I have my sql working now, I have created my csv file

Now I am struggling to get my writer to work

I have added the csv as a workspace resource using 'schema from table'

But its not writing anything

 

 

david_r
Celebrity
  • david_rCelebrity
  • August 31, 2018

The CSV writer doesn't know what to do with the Oracle "schema", you need to supply the schema as an attribute list, see https://knowledge.safe.com/articles/1051/index.html

Try inserting a SchemaSetter (from the FME Hub) before the writer, the custom transformer will create the schema attribute list for you.

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.