ORA-01747: invalid user.table.column, table.column, or column specification

Document ID : KB000115715
Last Modified Date : 24/09/2018
Show Technical Document Details
Issue:
An error occurs when using multiple bind variables with a SQL SEC VARA object that connects to an Oracle 12c Exadata database: 
ORA-01747: invalid user.table.column, table.column, or column specification
Environment:
Oracle 12c Exadata
Resolution:
Workaround:

Add a comment line (--) anywhere within the query.

Example:
 
SELECT A.EMPLOYEEID, A.EMPLOYEE_RECORDS, A.EFFDATE, A.EFFSEQ 
-- 
FROM EMPLOY A 
WHERE A.EMPLOYEEID = ? 
AND A.EMPLOYEE_RECORD= ? 

This will NOT throw an error.

However, removing the “--“ will cause the error to be thrown. 
 
Additional Information:
This issue only occurs in Oracle 12c Exadata database.