DSXchange

can anyone say how to call a stored procedure in Stored procedure stage of datastage? Currently i am calling as below

BEGIN Stored Procedure Name END;

But i am getting a syntax error. Can anyone suggest?

That's basically correct but you'll need to bind all of your columns into the call. It would also help if you posted the actual syntax error.

You could always tick the 'Generate procedure call' option and the stage will do it for you.

from your description it seems that your proecdure does not need input nor it is giving output.

so in your procedure stage just give the name of procedure in tab SYNTAX(Procdure Name) and select Procedure type (Transform).

hope it may help any issues please paste your error message for us to guide you accordingly.

The error is showing like this
Fatal: ORA-06550: line 1, column 7: PLS-00201: identifier 'TRUNC_WORK_IX_SPC_PROD_STAGE1' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Here TRUNC_WORK_IX_SPC_PROD_STAGE1 is my stored proc.

This procedure does need any input and also not givig any output.It is only for truncating a table.

Hello have you tried to execute your procedure from command line. i think you have an issue with procedure.

please check, if it not the case then we need to check for something else .....