cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
1491
Views
0
Helpful
2
Replies
indumathiIVR
Beginner

UCCX 8.5 - Accessing stored procedure result

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
Beginner

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.

Create
Recognize Your Peers
Content for Community-Ad