Skip to main content
Question

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


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.

3 replies

Forum|alt.badge.img
  • 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'


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

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
  • 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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings