UCCX 8.5 - Accessing stored procedure result

[indumathiIVR]

Hi,

I am trying to access a stored procedure through UCCX script.

I can access a stored procedure by following SQL query through DBRead step and it is successfully getting executed.

DECLARE         @return_value int,

                        @Result int;

            EXEC        @return_value = [dbo].[SP_ValidateUser]

                            @ContactPersonId =$input1 ,

                            @ContactPersonTypeid = $input2 ,

                            @Result = @Result OUTPUT;

         SELECT        @Result as '@Result'

I have to get the output of stored procedure in UCCX script variable. Is there any way to get it through DBGet Step.

Any help regarding this is greatly appreciated.

Thanks,

Indumathi.P

[jeeshthomas]

Hi Indumathi,

Have you got a response to this? I am also looking for a solution to get the output of Stored procedure in my UCCX local script variable. Can you kindly provide me with the script solution?

Thank you

Regards

Jeesh

[Daniel_HdezRivera]

Some body knows the answer for this discussion? I have the same problem...

Thanks for the help.