Can someone explain the difference between the two Oracle bulk load plugins that come with DS 6??
Thanks,
Damien[:)]
Difference between ORAOCIBL & ORABULK plugins
Moderators: chulett, rschirm, roy
Thanks Craig,
Why I ask is because when we try and use the ORAOCIBL stage I get errors. I believe that it is a version with Oracle, but I am not sure whether it is SQLNET or the Oracle Server version we are using.
We are using the ORAOCI8 stage with no problems.
The error we get when trying to use the ORAOCIBL stage is :
TestPB..ORAOCIBL_9: Internal Error: Unable to initialize the Direct Path Context
ORA-03115: unsupported network datatype or representation
The Oracle Error manual entry for ORA-03115 is :
ORA-03115: unsupported network datatype or representation
Cause: A user bind or define, or an Oracle function, is not supported by this heterogeneous Net8 connection.
Action: Upgrade the older version of Oracle and try again.
The current versions of Oracle software we are using are:
RDBMS 8.0.6.3.0 on HP/UX 10.20
SQL*NetServer 8.0.6.3.0 on HP/UX 10.20
SLQ*Net Client : 8.1.7.0.0 for NT2000
Can you point me in the right direction??
Thanks,
Damien
Why I ask is because when we try and use the ORAOCIBL stage I get errors. I believe that it is a version with Oracle, but I am not sure whether it is SQLNET or the Oracle Server version we are using.
We are using the ORAOCI8 stage with no problems.
The error we get when trying to use the ORAOCIBL stage is :
TestPB..ORAOCIBL_9: Internal Error: Unable to initialize the Direct Path Context
ORA-03115: unsupported network datatype or representation
The Oracle Error manual entry for ORA-03115 is :
ORA-03115: unsupported network datatype or representation
Cause: A user bind or define, or an Oracle function, is not supported by this heterogeneous Net8 connection.
Action: Upgrade the older version of Oracle and try again.
The current versions of Oracle software we are using are:
RDBMS 8.0.6.3.0 on HP/UX 10.20
SQL*NetServer 8.0.6.3.0 on HP/UX 10.20
SLQ*Net Client : 8.1.7.0.0 for NT2000
Can you point me in the right direction??
Thanks,
Damien
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Are you running DataStage on NT and the Oracle database on Unix? If that's the case then, according to the .pdf documentation, it just plain 'ol won't work. Both must be on the same "operating system type" in order to use the ORAOCIBL stage.
Plus, everything it mentions is for 8.1 (ie, 8i) not 8.0.
[:(]
-craig
Plus, everything it mentions is for 8.1 (ie, 8i) not 8.0.
[:(]
-craig