Stored procedure return value in process builder

1 answer

1.  

   1

   0

   -1

   • John Smith
   • May 30, 2024

   To save the stored procedure OUT variable value in a Joget process variable:

   1. Create Process Variable:

      • Create a process variable named procOutput in your Process Builder.

   2. Configure JDBC Tool:

      • In your form, add a JDBC Form Binder.
      • Write SQL to call the stored procedure:

        sql
        {? = call my_stored_procedure(?, ?)}
        

   3. Map Output to Process Variable:

      • Use a BeanShell script to set the process variable with the stored procedure’s OUT value:

        java
        # Assuming 'outputValue' holds the OUT parameter value
        workflowAssignment = workflowManager.getAssignment(activityId);
        workflowManager.activityVariable(workflowAssignment.getActivityId(), "procOutput", outputValue);
        

   This sets the procOutput variable with the value from the stored procedure.
   
   A documentation on this in the KB for you to read too : Call Stored Procedure - MySQL#CallingthestoredprocedureinJogetWorkflow
   
   Hope this helps!

   •  Comment

   CommentAdd your comment...