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:
Discussion posts and replies are publicly visible
Hi shubhamy, any reason why you are using a stored procedure?
Hi Richard,
I am updating the database table with some values periodically using stored procedure.
Hi Shubhamy,can you use Result Sets to get the case id comes from the stored procedure as output parameter.
Hi shubhamy0005,
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.