Skip to main content
Known Participant
Mar 13, 2023 9:24 AM UTC
Question

Issue with Stored Procedure

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
    Inspiring
    Mar 13, 2023 2:19 PM UTC

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

    Known Participant
    Mar 14, 2023 3:52 AM UTC

    Hi Richard, 

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

    srinivast0001
    Inspiring
    Mar 14, 2023 7:04 AM UTC

    Hi Shubhamy,

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

    sanchitg0002
    Inspiring
    Mar 14, 2023 9:08 AM UTC

    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.