cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
532
Views
0
Helpful
1
Replies

CCX Script DB Read Result from a Stored Procedure into a Variable

Kelin Webb
Level 1
Level 1

Afternoon all,
Logically, this feels like it should be an extremely easy thing to do.
I've called a Stored Procedure via DB Read and successfully returned the result that I need (number of rows returned = 1). I then want to take that result and toss it into a Variable to be used later on down in my script.

The process basically takes the caller's number and tosses it into the stored procedure to give us an account number (the returned row). How do I access that returned result to assign it to a variable?

1 Reply 1

David Moore
Level 1
Level 1

I think I would approach it like this:

Define an empty string variable.

Set (Variable name) on successful DB GET step

Or if passing to finesse or another script, set enterprise call info step (variables used)