invalid user.table.column...

Four Stars

invalid user.table.column...

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,

HB

Highlighted
Moderator

Re: invalid user.table.column...

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Managing a Stewardship Campaign

In this video, you will see how to assign your best team members specific tasks to reconcile, correct, merge, arbitrate or group pre-determined data and achieve quality, clean data in a limited time

Watch Now

Talend Data Stewardship – What does it have to offer?

In this short series, you will see how Talend Data Stewardship transforms your employees into data citizens and enables them with self-service capabilities to control their quality data

Watch Now