invalid user.table.column...

Anonymous — Sat, 16 Nov 2024 09:14:13 GMT

Hello,

Can you please help me to solve this issue?

Exception in component tOracleInput_1
java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or columns specification

Here is my query:

"select i.REFERENCE_NUMBER, i.INVOICE_DATE
from INVOICE i
where i.FLAG_EXPORTED = 'Y'
and i.INVOICE_DATE = to_date((java.util.date)globalMap.get(\"row8.date_fin\"),'yyyy/mm/dd')"

Thanks.

Regards,

Re: invalid user.table.column...

Anonymous — Sat, 30 Sep 2017 15:00:30 GMT

Hello,

This error indicates the Oracle parser thinks that one of your columns or tables is not valid. And please have a look at your code tab to see any syntax error in the INSERT statement from generated java line.

Best regards

Sabrina

topic invalid user.table.column... in Data Quality

invalid user.table.column...

Re: invalid user.table.column...