STPPX STAGE Settings Problem

[chvenkat.v]

I have a Orcle SQL Stored procedure with two input columns of type date data type, no output column. How do I call the stored procedure in DataStage using the STP stage?

The error I am getting is not very helpful and is given below:

SP_PS_M,0: Error occurred in call to ORPHCallActivePluginInitialize().
SP_PS_M,0: The runLocally() of the operator failed.

...

and i have other query

in server jobs i am calling stored procedure by job control code. in px how to call stored procedure.

how to import meta data of strored procedure in PX.

[ray.wurlod]

Import Table Definition is independent of job type, so you can import your stored procedure definition exactly as you would if you were intending to use it in a server job.

The fact that the function failed to initialize may mean that the Stored Procedure stage has not been properly installed or registered, or perhaps that a vital directory has been omitted from your shared library search list.