In Scribe Online, how do I access the output/return parameters of a Microsoft SQL Server stored procedure

[Cantata Support]

The Execute block for the stored procedure has the following "OPERATION RESULTS" fields, but no stored procedure output/return parameters:

 

Result.ErrorDescription

Result.ErrorDetail

Result.ErrorNumber

Result.RecordsMatched

Result.Success

 

 

Many thanks.

 

Regards, Jim.

[Cantata Support]

After some experimenting... the output/return parameters are available to use in subseqeunt blocks, e.g. Execute, Update, but not in an If Else control block.

[Karen Porter]

@JP337293 Is there some other secret to getting the output/return parameter I'm trying to use it in a subsequent Execute block and I'm not seeing it available.

[Darryl Ma 2]

Support helped me with this exact problem.  Just typing in the blockname.ReturnValue gave me the data I expected. 

 

For example:

 

GPeConnect_taPMTransactionInsertExecute.ReturnValue

 

(GPeConnect_taPMTransactionInsertExecute is the name of the Execute block running the stored procedure)

 

Perhaps there is a limitation where stored procedure output parameters can't be dispalyed in the Operation Results area of Execute blocks.  Hope this helps.