GitHub user bamaer added a comment to the discussion: Oracle Table Input with
variables (${LAST_RUN_TS}, ${LAST_RUN_ID}) failing in Apache Hop
Your parameterized query and the screenshot bot look correct, but there could
be subtle issues that we're missing from the limited information here.
> When using variables in the Table Input, the pipeline either Interprets them
> as literal strings
That's because that is what happens. The variables in your query are parsed
before the query is sent to the query as a sql string. The variable doesn't
prevent any SQL injection or similar. Try hovering over your variables to see
what their exact values are, write your parsed SQL to the logs with a Write To
Leg etc to troubleshoot and to make sure the SQL is exactly what you expect it
to be.
An alternative approach could be to pass data from fields with the "insert data
from transform" option, but you'll need to prepare your input stream correctly
in that case. Check the docs and the examples in the samples project.
What you're trying to do is a common use case and is widely used, it shouldn't
be too much of a problem to get it to work.
GitHub link:
https://github.com/apache/hop/discussions/6250#discussioncomment-15324800
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
