ODI - 1228: the target tasks on ORACLE connection XWJMB de_wj (integrated) failure,
Under Caused By: Java. SQL. SQLSyntaxErrorException: ORA - 01747: user. Table. The column, table. The column or columns that invalid
Below is the code
/* DETECTION_STRATEGY=NOT_EXISTS */
The update WJMB. DEPT T
Set
The where (B_DEPTNO)
In (
The select B_DEPTNO
The from WJMB i. $_DEPT
Where IND_UPDATE='U'
)
Create a table column name no keywords, but has been to the wrong,
CodePudding user response:
The last asked this question?Behind the set in your SQL is blank? On purpose? Or was so?