cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1614
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.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: