Is there a way to call a pipelined function with parameters and then read the results as a table in FME desktop? I am only interested in non-spatial attributes being used.
Thanks in advance...
Solved
Can FME call and read from an Oracle pipelined function?
Best answer by erik_jan
I think the SQLCreator should be able to do that.
This transformer acts as a reader, based on a SQL statement.
The statement will be passed to the database and the result will be read into FME.
Hope this helps.
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.
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.
+23- Contributor
- Best Answer
I think the SQLCreator should be able to do that.
This transformer acts as a reader, based on a SQL statement.
The statement will be passed to the database and the result will be read into FME.
Hope this helps.
Thanks Erik, that works great. Make sure to specify Automatic or Manaul for user attributes for anything consuming the data however, since FME does not pre-parse the return types for Dynamic with this type of call.