I didn't find 'missing right parenthesis'

[Eric_Talend]

Hi everybody,

I have this error :

'missing right parenthesis'

I search, I search, I made some tests but I didn't solve this problem.

I execute my job until "Tlogrow", it's ok, I see my data on the screen.

But, when I add the component to put the data to the Oracle database, I have the message :

'missing right parenthesis'

Somebody has an idea ?

Many thanks.

[manodwhb]

@Eric Vincent​ , are you creating able in tOralceOutput?

[manodwhb]

@Eric Vincent​ ,check the below link may help.

https://www.talendforge.org/forum/viewtopic.php?id=37389

[Eric_Talend]

@Manohar B​ : thanks for you answer

This is the component that I use

For the lik to talendForge, I read all the discussion but I didn't find the solution for me 😞

[manodwhb]

@Eric Vincent​ , What is the Action on Table?

to sort the problem ,specify none and create a table using sql developer something like that and check the data types are matching and see are you getting the error.

[Eric_Talend]

Yeh, I found the solution.

I don't know why but there was a wrong definition : object instead integer.

So, if you have the same message, first you must verify the declaration one by one.

Enjoy.

[manodwhb]

@Eric Vincent​ , Please mark the answer so that it would be helpful to others.