Procedure Status in Stored Procedure stage

Praful · Post by **Praful** » Wed Apr 16, 2014 9:49 am

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.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Wed Apr 16, 2014 1:18 pm

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

Praful · Post by **Praful** » Wed Apr 16, 2014 1:47 pm

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",""

prasson_ibm · Post by **prasson_ibm** » Tue Apr 22, 2014 4:17 am

Hi,

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