Oracle redoLog CDC raisng ORA-00923: From keyword not found

[Anonymous]

Hello,
I've followed the tutorial "how to set up CDC in Oracle Redo/Archive log mode" - 
and I get the above exception.
My source table is CUSTOMERS (id, name, address).
When debugging the code, i notice that the following query is the one raising the exception:
select "id, "name", "address" operation$ TALEND_CDC_TYPE,COMMIT_TIMESTAMP$ TALEND_CDC_CREATION_DATE
from "TCDC_L00001"
where TALEND_CDC_STATE='1' order by TALEND_CDC_CREATION_DATE asc;
ORA-00923: From keyword not found where expected.
any ideas?
thanks,

[Anonymous]

Hi,

ORA-00923: From keyword not found where expected.

Can you use your statement select "id, "name", "address" operation$ TALEND_CDC_TYPE,COMMIT_TIMESTAMP$ TALEND_CDC_CREATION_DATE
from "TCDC_L00001"
where TALEND_CDC_STATE='1' order by TALEND_CDC_CREATION_DATE asc; on oralce management successfully?

Best regards
Sabrina

[Anonymous]

hi, Sabrina.
The query is not running from the same reason: 

ORA-00923: From keyword not found where expected.

I suspect the problem is with the  "address" operation$ string. There seems to be a comma missing between them.
If I insert a comma, then
select "id, "name", "address", operation$ TALEND_CDC_TYPE,COMMIT_TIMESTAMP$ TALEND_CDC_CREATION_DATE
from "TCDC_L00001"
where TALEND_CDC_STATE='1' order by TALEND_CDC_CREATION_DATE asc;
 returns
id | name | address | talend_cdc_type | talend_cdc_creation_date
--------------------------------------------------------------------------
1  | david | london  | I                        | 10/09/2015 15:30:02
2  | jon    | paris     | I                        | 10/09/2015 15:30:05

Since I can't intervene in the Talend code, I have a problem.

Thank you.

[Anonymous]

Hi,
There is a typo in your select query. The double quotes were not included properly in id selection.

[Anonymous]

well that's just a typo....
the generated sql includes the quotes, but not the comma.
so the correct post would be:
.
.
.
select "id", "name", "address" , operation$ TALEND_CDC_TYPE,COMMIT_TIMESTAMP$ TALEND_CDC_CREATION_DATE
from "TCDC_L00001"
where TALEND_CDC_STATE='1' order by TALEND_CDC_CREATION_DATE asc;
 returns
id | name | address | talend_cdc_type | talend_cdc_creation_date
--------------------------------------------------------------------------
1  | david | london  | I                        | 10/09/2015 15:30:02
2  | jon    | paris     | I                        | 10/09/2015 15:30:05
Since I can't intervene in the Talend code, I have a problem.

Thanks you.

[Anonymous]

Hi, Sabrina.
Is there a solution?

Thanks