DB_WB_SRC02,0(Object : Oracle Connector name): The OCI function OCIStmtExecute returned status -1. Error code: 8,103, Error message: ORA-08103: object no longer exists. (CC_OraStatement::executeSelect, file CC_OraStatement.cpp, line 2,642)
The design is very simple and it is ok if I ran it out of the sequence.
Code: Select all
OC1---> Transf__ >
OC2---> Transf~~ > Funnel -> OC
OC1 is all good. OC2 is having this problem.
In OC2, using sql and is is as follows:
select column1 as fund_short_nme,
column2 as external_taxp_id,
round(abs(column3) / column4, 10) as tax_deferred,
round(abs(column5) /column4 10) as tax_free,
round(abs(column6) /column4, 10) as indexed_tax_deferred
from table1 cg,
table2 wb,
table3 wp,
table4 st,
table5 tp
where ......
Can you please give me some idea where it is wrong.
I did try couple of things and same result..