Could not load dsstpora.dll Stored Procedure Call

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
WesL
Premium Member
Premium Member
Posts: 26
Joined: Wed Jun 28, 2006 1:05 pm
Location: Huntsville, AL

Could not load dsstpora.dll Stored Procedure Call

Post by WesL »

Morning - I know this issue has been discused with the 7.x platform but it appears that all posts were from the 2007 timeframe and some of the directories and such have changed.

We got this error yesterday while running a job that uses a stored procedure call to an Oracle 10g server. We have the Oracle 11g client installed due to the fact that several other jobs use an 11g database to run.

After reviewing the previous posts from 2007 I did check for the oraoci9.dll file that was mention but it was located in X:\IBM\InformationServer\Server\DSComponents\bin instead of the location listed for the older version. Can anyone firm this is the correct location?

Thanks,

Wes
Post Reply