topic Re: tOracleOutputBulkExec_2_tOBE ORA-00942: Table ou vue inexistante in Talend Studio

tOracleOutputBulkExec_2_tOBE ORA-00942: Table ou vue inexistante

pkp85pkp — Wed, 13 Jun 2018 14:45:19 GMT

Hi,

I have this error message :

tOracleOutputBulkExec_2_tOBE ORA-00942: Table ou vue inexistante

For this component tOracleOutputBulkExec in update mode it is necessary to describe all fields of the table even the fields which does not go updated?

Thanks in Advance

Re: tOracleOutputBulkExec_2_tOBE ORA-00942: Table ou vue inexistante

TRF — Wed, 13 Jun 2018 14:49:36 GMT

Not at all.

Are you sure the schema is well defined within your tOracleConnection or tOracleOutputec component?

Re: tOracleOutputBulkExec_2_tOBE ORA-00942: Table ou vue inexistante

pkp85pkp — Wed, 13 Jun 2018 15:20:38 GMT

Yes i am sure.

When i define all fileds in my component tOracleOutputBulkExec it works but when i define just a part of fileds it not works only for update mode.

Re: tOracleOutputBulkExec_2_tOBE ORA-00942: Table ou vue inexistante

manodwhb — Thu, 14 Jun 2018 07:35:41 GMT

@pkp85pkp,have you defined fields in tOracleOutputBulkExec schema,which are do not to want to update?

if you please remove those.

Re: tOracleOutputBulkExec_2_tOBE ORA-00942: Table ou vue inexistante

pkp85pkp — Thu, 14 Jun 2018 07:50:13 GMT

i have 2 scenario :

1) i defined all fields of my table in tOracleOutputBulkExec schema,and i update : it is work (picture1)

2) i defined just a part of fields of my table in tOracleOutputBulkExec schema,and i update : it is not work (picture2) merror message : tOracleOutputBulkExec_2_tOBE ORA-00942: Table ou vue inexistante

I did not change anything just the number of fields in the schema !!!

)

picture1.png