tOracleOutputBulkExec_2_tOBE ORA-00942: Table ou vue inexistante

[pkp85pkp]

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

[TRF]

Not at all.

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

[pkp85pkp]

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.

[manodwhb]

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

if you please remove those.

[pkp85pkp]

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