Error while fetching records through Oracle connector stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sharmabhavesh
Premium Member
Premium Member
Posts: 38
Joined: Tue Jun 19, 2012 11:03 pm
Location: India

Error while fetching records through Oracle connector stage

Post by sharmabhavesh »

Hi,
I am trying to connect to Oracle through connector stage. I am able to view data through the 'view data' option. But when I run the job to extract data, it gives me the following error:

Oracle_Connector_16: The OCI function OraOCIEnvNlsCreate:NLS_LANG returned status -1. Error code: NULL, Error message: NULL. (CC_OraConnection::allocateOCIHandles, file CC_OraConnection.cpp, line 2,036).

anyone faced a similar issue.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Involve support. I could make a guess based on it having something to do with "allocateOCIHandles" but it would be just that, a guess. Seek professional help. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Involve your DBA, because it may be that more Oracle listeners need to be configured.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”