Skip to main content
Solved

Oracle reader table name exposed as attribute?

  • Jul 13, 2018 3:50 PM UTC
  • 1 reply
  • 149 views

Forum|alt.badge.img

How can I expose the "table name" parameter in the dialog box of the Oracle reader as an attribute I can use in a writer (to force it lowercase)?

Best answer by andreaatsafe

Hi @hallkbrdz,

If you expose the format attribute "fme_feature_type" on the Oracle reader, you should get the Schema.Table name from the Oracle reader. Then you could use a StringReplacer to remove the "Schema." from the attribute values to get just the table name.

- Andrea

View original
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.

1 reply

andreaatsafe
Safer
Forum|alt.badge.img+17
  • Safer
  • Best Answer
  • Jul 13, 2018 4:32 PM UTC

Hi @hallkbrdz,

If you expose the format attribute "fme_feature_type" on the Oracle reader, you should get the Schema.Table name from the Oracle reader. Then you could use a StringReplacer to remove the "Schema." from the attribute values to get just the table name.

- Andrea