Hi All,
I am using oracle connector stage without any reject link right now..
and getting following errors for Bulk Load..
Tble: [IIS-CONN-ORA-004006] The connector generated the following TRUNCATE TABLE statement at runtime: TRUNCATE TABLE TBLE_NAME.
[IIS-CONN-ORA-004009] The connector truncated the table TBLE_NAME.
Tble: [IIS-CONN-ORA-001003] The OCI function executeDirect returned status -1. Error code: 942, Error message: ORA-00942: table or view does not exist. (CC_OraLoad::executeStatement2, file CC_OraLoad.cpp, line 2,858)
While target table is still on the database , I am getting above errors.
And what should be given in "Exceptions table name" property,
though I read the manual for it still kind of unclear.
Any inputs greatly appreciated.
Thank you all.
Oracle connector error .
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Sat Nov 14, 2009 3:38 am
-
- Participant
- Posts: 22
- Joined: Tue Jul 21, 2009 4:45 am
- Location: Chennai
- Contact:
Hi,
check out for the CASE sensitivity of the table name. Check whether you have specified the right table name as on the SQL devoloper query builder or not.
because in some cases the ORA table names are case sensitive.
And may i know what kind of operation you are undergoing in the oracle stage?
check out for the CASE sensitivity of the table name. Check whether you have specified the right table name as on the SQL devoloper query builder or not.
because in some cases the ORA table names are case sensitive.
And may i know what kind of operation you are undergoing in the oracle stage?
Thanks & regards
Satish R
Satish R
Was this issue ever resolved?
If it was resolved then what was the solution? Was it setting the NLS_LANG parameter?