DSXchange

Not all that much better. You're still repeating yourself. And you need something more than an icon in the body of the post.

The OCI stage in 7.5.1a (maybe 7.5?) is where official support for 10g arrived, from what I recall. Doesn't mean you couldn't access it in earlier versions, just that it wasn't "officially" supported. We accessed 10g via a 9i client without issue, for example.

Jagan617 wrote:

Use the latest plugin whatever is available...It's easier, if any upgrades happen on Oracle side in the future....using some of the utilities available in DS we can update the Oracle project accordingly on datastage side too.....

We use the OCI stage to connect to our 10G.

chulett wrote: The OCI stage in 7.5.1a (maybe 7.5?) is where official support for 10g arrived, from what I recall. Doesn't mean you couldn't access it in earlier versions, just that it wasn't "officially" supported. We accessed 10g via a 9i client without issue, for example.

We use ORAOCI 9 stage (if that is what you are expecting as an answer!). First you need to install the 10g client on the Server.

chulett wrote: The OCI stage in 7.5.1a (maybe 7.5?) is where official support for 10g arrived, from what I recall. Doesn't mean you couldn't access it in earlier versions, just that it wasn't "officially" supported. We accessed 10g via a 9i client without issue, for example.

We use ORAOCI 9 stage (if that is what you are expecting as an answer!). First you need to install the 10g client on the Server.

Instead of oracle oci stage, you can use DRS stage, it support oracle 10g version database.