Home > database >  ODI integration error
ODI integration error

Time:09-22

It is at fault:
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?
  • Related