Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

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


Cantata Support

Recommended Posts

  • 1 year later...
  • 4 months later...

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.

Link to comment
Share on other sites

×
×
  • Create New...