topic Re: I didn't find 'missing right parenthesis' in Talend Studio

I didn't find 'missing right parenthesis'

Eric_Talend — Sat, 16 Nov 2024 01:46:25 GMT

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.

Re: I didn't find 'missing right parenthesis'

manodwhb — Thu, 30 Jul 2020 10:40:18 GMT

@Eric Vincent , are you creating able in tOralceOutput?

Re: I didn't find 'missing right parenthesis'

manodwhb — Thu, 30 Jul 2020 10:46:17 GMT

@Eric Vincent ,check the below link may help.

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

Re: I didn't find 'missing right parenthesis'

Eric_Talend — Thu, 30 Jul 2020 12:54:52 GMT

@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 😞

Re: I didn't find 'missing right parenthesis'

manodwhb — Thu, 30 Jul 2020 13:11:32 GMT

@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.

Re: I didn't find 'missing right parenthesis'

Eric_Talend — Thu, 30 Jul 2020 13:35:21 GMT

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.

Re: I didn't find 'missing right parenthesis'

manodwhb — Thu, 30 Jul 2020 15:26:32 GMT

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