Difference between ORAOCIBL & ORABULK plugins

[kavo]

Can someone explain the difference between the two Oracle bulk load plugins that come with DS 6??

Thanks,

Damien[:)]

[chulett]

Basically, here is my understanding...

ORAOCIBL uses the Oracle Call Interface (OCI) to bulk load data directly into Oracle in your job.

ORABULK builds the control and data files from a source that you would then *manually* (or externally) bulk load by issuing the 'sqlldr' command yourself.

-craig

[kavo]

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

[ray.wurlod]

Does the executing user require BIND privilege?

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

[chulett]

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