Skip to main content
S
shubhamy0005
March 13, 2023
Question

Issue with Stored Procedure

  • March 13, 2023
  • 4 replies
  • 0 views

Dear All,

I have created a stored proc which is returning an output parameter 'caseid' and I would like to access the case id in stored proc smart service. But I am getting error incorrect number of argument passed. Please correct me if I am doing something wrong. I have attached the screenshots below:

    4 replies

    richardm900458
    richardm900458
    March 13, 2023

    Hi shubhamy, any reason why you are using a stored procedure? 

    S
    shubhamy0005Author
    March 14, 2023

    Hi Richard, 

    I am updating the database table with some values periodically using stored procedure.

    srinivast0001
    srinivast0001
    March 14, 2023

    Hi Shubhamy,

    can you use Result Sets to get the case id comes from the stored procedure as output parameter.

    S
    sanchitg0002
    March 14, 2023

    Hi [mention:9e801b4ea7ba47db8735359b555491e6:e9ed411860ed4f2ba0265705b8793d05],

    This is some weird issue with this smart service, I have also gone through this problem.

    It gave me error for the parameter (IdNumber) which I previously had in my SP but it is dropped now, it just do not refreshes or Idk what?

    The only solution which I finally came across is to Drop the SP from database and create it back again. Surprisingly it worked, give it a try.

    Terms & ConditionsAccessibility statement