I'm new on FME and want to know if is there a way to store an oracle select as constant? This value will be used to update some oracle tables.
Question
How to store a select result in a constant
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.
+15- Contributor
Hi,
Do you want to store the statement or part of it and use it in a SQL-Creator/Executor?
You can simply create the statement or part of it (or an entire query) in a attribute.
Assemble your query in the SQL-Creator/Executor using the previously created attribute(s).
(basically a "pseudo dynamic query" using fme. Much easier then true dynamic query using oracle)
Just be aware that you cannot populate with pseudo dynamic queries. ( you will have to use a non dynamic to populate (a simple select * will do) it and then replace the query with the dynamic version).
But if you want to store a select statement or part of it, and access this using oracle sql, you can if you store it in excel/txt and then access the excel/txt trough oracle.