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.
+18- 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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.