ORA-00933: SQL command not properly ended

Anonymous — Tue, 20 Dec 2016 09:53:28 GMT

Hi, I face a similar problem. My job flow is tOracleIput-->tJavaRow-->on component ok-->tOracleInput-->tOracleOutput. I am giving a query in toracleinput component : "SELECT * FROM incr_source where incr_source.invoice_date > "+context.incrementaldate+""
It gives me an error saying: Exception in component tOracleInput_2
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
What is the correct syntax? Please help. Thanks

Re: ORA-00933: SQL command not properly ended

Anonymous — Wed, 21 Dec 2016 08:57:10 GMT

Hi
What's data type of invoice_date field? Make sure the value of context. incrementaldate is not null or empty. For testing, print the value of context. incrementaldate on tJavaRow.

Regards
Shong

topic Re: ORA-00933: SQL command not properly ended in Talend Studio

ORA-00933: SQL command not properly ended

Re: ORA-00933: SQL command not properly ended