No patch is required. Go to your DBA's and ask them to help you set your Oracle client settings right on the server where DataStage runs.
What you see happening now depends on a combination of Oracle client settings and Oracle instance settings so a general answer is not that easy given.
Also if you already are using Oracle databases via DataStage it may not be so easy to change either server or client setting.
Ogmios
Patch for oracle stage
Moderators: chulett, rschirm, roy
Re: Patch for oracle stage
In theory there's no difference between theory and practice. In practice there is.