this kind of output my SP giving me, and I have used print statement of SQL to print this output,
but when I call SP with the correct input Parameter then it's not returning the result.
Discussion posts and replies are publicly visible
Please provide more details.
Yeah we can't really tell what you might be doing wrong if you don't provide the code snippet you're using to try and call your SP. And maybe also an anonymized screenshot of the SP (or at least its first few rows or something).
It is tough to figure out with the provided details. Please provide your expression rule code to analyse further
Hello vishalk3261
Please share the stored procedure that you have written and also the ER that you are trying to execute and also provide the input and the expected output if possible.
Hi,vishalk3261 Firstly could you share your SP code please, that would help to debug the issue, May I know if there is any condition present in SP that returns this message "Value already there"? If yes, could you check your input values to the SP you are passing and also the return variables you are using in your SP?
Share your code please.....
Do you see any errors in tomcat-stdout.log?
Does the SP works as expected when executed in DDBB?