Author Topic: Stored Procedure Output variables  (Read 2432 times)

Offline karthi.ariraman

  • Newbie
  • *
  • Posts: 1
  • Karma: 0
Stored Procedure Output variables
« on: May 08, 2014, 06:56:54 PM »
Hi,

    I am trying to execute a stored Procedure using DB Data Block in composer 8.1.3. But I am facing an issue in storing the output variables.In most of the genesys document says Output values are stored in Parameters pane "Value" field. Now my question is how to access the "Value" field variables in to other blocks.Any idea or any example of assign would be helpful.

Thanks
Karthik

Offline gzooby

  • Full Member
  • ***
  • Posts: 141
  • Karma: 0
  • Software Engineer at Telefax S.A.
Re: Stored Procedure Output variables
« Reply #1 on: May 14, 2014, 04:12:52 PM »
For storing the return values of the stored procedure block I suggest you define certain variables in the main block as "Callflow variables" so then in the stored procedure block you assign the return result into those variables, which will be available from any block later.

Hope it helps! :) :)