DSXchange

I am calling the procedure through stored procedure stage and pasing procedure status to sequential file.

General-->Database Vendor=Oracle
Syntax-->procedure type = source.
no parameters and no error code

I am intentially failing the procedure to see the procedure status in the file, but status is not going to the sequential file. If procedure ran good then status is populating good.

Job:
Stored Procedure --> Sequential file stage

Can you please let me know how to populate the status if procedure fails.

On the Output -> General tab of the Stored Procedure stage do you have "Procedure Status to Link" box checked?

Yes that box is checked, but still not getting the status if procedure is failing.
If procedure ran good then status is coming in the file as below,

"0",""

Hi,

In case procedure is failing what return code you are getting in file?