Skip to main content
Question

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

  • Aug 30, 2018 9:39 PM UTC
  • 3 replies
  • 116 views
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

Forum|alt.badge.img
  • jacq
  • Author
  • Aug 31, 2018 1:24 AM UTC

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'

Forum|alt.badge.img
  • jacq
  • Author
  • Aug 31, 2018 1:25 AM UTC

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
  • Aug 31, 2018 7:06 AM UTC

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,989
Posts
125,019
Replies
41,907
Members
Terms & ConditionsAccessibility 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.