One Star

tOracleBulkExec errorORA-00942: table or view does not exist

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 Smiley Sad
Regards
Ricardo Mendes
7 REPLIES
One Star

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

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

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

Hi,
And pay attention on "Case Sensitive".
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

I've checked all the configurations Smiley Happy but still doesn't work Smiley Sad
Moderator

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

Hi,
Have you checked DB "Permissions"? Could you get the table by your user role?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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 Smiley Sad
Moderator

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

Hi,
Could you please show us your whole workflow? What's your job requirement?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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!