This is marked as resolved, but the above discussion did not help that much.
However, I did find a solution by keeping my record count at the default 2000 option, and my array size to 100,000. This solved the issue if anyone runs into this again.
My total record count was ~1 million.
Lisa
Search found 2 matches
- Thu Jan 24, 2013 11:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IIS-CONN-ORA-001003, ORA-24381
- Replies: 13
- Views: 18471
- Wed Jan 23, 2013 11:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connector Stage - ORA 1406
- Replies: 12
- Views: 96975
None of the discussed solutions work, is there another?
Hello,
Is there any other updates to this discussion?? Switching to NVARCHAR does not work, nor does making the varchar(96). Its marked as resolved, but I am not sure it should be.
Is there any other updates to this discussion?? Switching to NVARCHAR does not work, nor does making the varchar(96). Its marked as resolved, but I am not sure it should be.