• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » new oracle configuration failed for existing talend component

#1 2010-05-13 17:04:12

A C
Guest

new oracle configuration failed for existing talend component

Tags: [oracle, sql, syntax]

we have a set of jobs which are running with oracle 10.
all have been working for a while.
we now switch to a new vendor's oracle database.
once switched, those jobs failed. oracle connection has no problem
but it seems that new oracle can't receive sql statement properly.
we keep getting ORA-xxxx errors across different jobs.

for example tOracleOutput, we can get this
ORA-00926: missing VALUES keyword

how should we look into this kind issue?

#2 2010-05-14 08:23:54

shong
Talend team
Registered: 2007-08-29
Posts: 10289
Website

Re: new oracle configuration failed for existing talend component

Hello
Yes, there is some syntax error in the SQL statement, see ora-00926, open the code tab and show us the SQL statement.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2012-07-03 17:40:42

rangababu
Member
Registered: 2011-06-08
Posts: 22

Re: new oracle configuration failed for existing talend component

Hello

I got the same error.ora-00926:missing VALUES keyword.
I opened the code tab , but didnt get any error.

Could you please update on this.

Thanks

Offline

#4 2012-07-03 17:41:42

rangababu
Member
Registered: 2011-06-08
Posts: 22

Re: new oracle configuration failed for existing talend component

Hi Shong

Could you please help on this.

Thanks
Ranga

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » new oracle configuration failed for existing talend component

Board footer

Powered by FluxBB