Skip to main content
Nintex Community Menu Bar

SMO ISSUE : SQL STORE PROC WITH 1 INPUT PARAMETER AND 3 OUTPUT PARAMETERS

  • June 8, 2018
  • 1 reply
  • 13 views
H

Hello All

i created an smo which takes 1 input and 3 output parameters.Executed storproc in sql and works as expected when i send input parameter which is required parameter and get my output.

 

when i create an smo to execute storeproc execute method in smo tester tool it asks all 4 parameters(1 input and 3 output) as REQUIRED.

 

In sql while executing it works as expected passing 1 parameter which is input iam getting 3 output parameter result.

 

Anyone faced this and any suggestion

 

Username input i get output parameters as expeced

    1 reply

    K
    Forum|alt.badge.img+9
    • Kran
    • June 8, 2018

    Hi Haridoll1,

     

    While creating stored procedure , pass output parameter default value  as null,  refer below example

     

     

    Create procedure Sp_GetEmployeeDetails 
    (
    @Id int,
    @EmployeeCode nvarchar(max)=null OUTPUT,
    @EmployeeFirstName  nvarchar(max)=null OUTPUT,
    @EmployeeLastName  nvarchar(max)=null OUTPUT
    )
    as
    Begin
    SELECT @EmployeeCode=[EmployeeCode]
          ,@EmployeeFirstName=[EmployeeFirstName]
          ,@EmployeeLastName=[EmployeeLastName]
        
      FROM   dbo.employeedetails where Id=@Id

    End

     

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement