DSXchange

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.

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.