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

1 REPLY
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.