Error while loading data into oracle table
Moderators: chulett, rschirm, roy
Error while loading data into oracle table
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.
Nirdesh Kumar
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Nirdesh Kumar