cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1753
Views
0
Helpful
2
Replies

UCCX 8.5 - Accessing stored procedure result

indumathiIVR
Level 1
Level 1

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

2 Replies 2

jeeshthomas
Level 1
Level 1

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

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

Thanks for the help.