Stored Procedure output Error mensajes

[Gius]

Hello,
When I use in the job a stored procedure stage, it have two output fields
ProcCode , ProcMess

How can I populate those two variables from the Stored Procedure.
Also, when I do a RETURN x in the stored procedure, how can I capturate this value ?

Thank you

[Gius]

Is a BD2 database !

[chulett]

When I use in the job a stored procedure stage, it have two output fields
ProcCode , ProcMess

How can I populate those two variables from the Stored Procedure.

Do you actually mean two input fields? If they are output fields, the procedure is already populating them, I would assume.

Also, when I do a RETURN x in the stored procedure, how can I capturate this value ?

From what I recall, the Stored Procedure stage supports three kinds of procedure types: source, target and transform. If you just want to call it and read the return value, it would be a 'source'. If you need to pass data into it when you call it and don't have any output fields, then it is a 'target'. To do both, which I'm guessing is what you need to do, it would be as a 'transform'.

[chulett]

All that being said, what are you trying to return? Is 'x' some kind of value or values or is it just the status of the procedure run?