Stored Procedure 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
Suparv
Participant
Posts: 17
Joined: Wed Aug 25, 2004 9:33 am
Location: Pennsylvania

Stored Procedure Stage

Post by Suparv »

Hi

I am trying to use the Stored Procedure Stage, which uses a Transform procedure type, I have mapped the input and output parameters correctly. I want to call a function, with which returns a value for each row.
I keep getting the following error while trying to run the job.

Stored_Procedure_3,0: Error occurred in call to ORPHCallActivePluginInitialize().

Could someone help me get rid of this error?

I am currently working on the Datastage Px 7.5.1A, database being used is Oracle 10g

Thanx
Suparv.
Top
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Just wondering are you using the lib32 library of the 10g client?
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Top
Post Reply

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