topic Re: tOracleBulkExec errorORA-00942: table or view does not exist in Talend Studio

tOracleBulkExec errorORA-00942: table or view does not exist

Anonymous — Tue, 11 Mar 2014 09:31:34 GMT

Hi,
I have a job that is updating a large amount of records but when executing the tOracleBulkExec gives the message
java.sql.SQLException: ORA-00942: table or view does not exist
I've set the correct database and table but doesn't work
Regards
Ricardo Mendes

Re: tOracleBulkExec errorORA-00942: table or view does not exist

Anonymous — Tue, 11 Mar 2014 09:40:44 GMT

Hi Mendesr
Have you checked correctly the schema and database in all fields of tOracleBulkExec??
DATABASE.schema.TABLE
Cheers

Re: tOracleBulkExec errorORA-00942: table or view does not exist

Anonymous — Tue, 11 Mar 2014 09:43:34 GMT

Hi,
And pay attention on "Case Sensitive".
Best regards
Sabrina

Re: tOracleBulkExec errorORA-00942: table or view does not exist

Anonymous — Tue, 11 Mar 2014 09:58:47 GMT

I've checked all the configurations but still doesn't work

Re: tOracleBulkExec errorORA-00942: table or view does not exist

Anonymous — Tue, 11 Mar 2014 10:15:13 GMT

Hi,
Have you checked DB "Permissions"? Could you get the table by your user role?
Best regards
Sabrina

Re: tOracleBulkExec errorORA-00942: table or view does not exist

Anonymous — Tue, 11 Mar 2014 10:27:12 GMT

Hi, yes I can get the table by my role, the first step is to read rows from that table and if I use tOracleOutput to update the table it works but takes 3 minutes to update 50 rows

Re: tOracleBulkExec errorORA-00942: table or view does not exist

Anonymous — Wed, 12 Mar 2014 03:10:15 GMT

Hi,
Could you please show us your whole workflow? What's your job requirement?
Best regards
Sabrina

Re: tOracleBulkExec errorORA-00942: table or view does not exist

Anonymous — Mon, 13 Jul 2015 12:53:44 GMT

I also get a similar error on TOS - 5.6.2 with tOracleOutputBulkExec.
Mine is a simple flow - Delimited_file (all strings) -> tMap (to covert 2 columns to an Int and Date) -> tOracleOutputBulkExec
Attaching screenshot for both the Basic and Advanced properties of tOracleOutputBulkExec here!
Also, I'm trying to Bulk-Update the table with this, with proper Keys defined in the schema!

Any help is much appreciated!