Error while loading data into oracle table

nirdesh2 · Post by **nirdesh2** » Thu Apr 23, 2009 12:51 am

We are getting the following error while loading data into Oracle table using Load and Appened method "Error when checking composite operator: Caught parsing exception during wrapDescribeOperator(): Could not find type: oratype:0". When we use upsert method, table is loaded without error. Only issue is with Load method.

ArndW · Post by **ArndW** » Thu Apr 23, 2009 5:33 am

I don't know what the cause is, but seeing the word "type" would lead me to look at what Oracle data types you are using.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 23, 2009 2:31 pm

Take a look at the score for this step (job). What are the operators that make up the composite operator?

nirdesh2 · Post by **nirdesh2** » Fri Apr 24, 2009 12:55 am

This problem is not occuring for single job but also occuring for all the jobs where we are loading the data in Load append mode while working fine when we change the mode to Upsert.Actually we have 2 schema on same database and tables are also same in both schema. In one schema we have public synonyms and in other one we have private syononys. It working fine with public synonys while giving error when working with private synonym.