Skip to main content
Participating Frequently
September 13, 2024
Question

Stored Procedure output Not Visible in appian .

  • September 13, 2024
  • 6 replies
  • 0 views


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.

6 replies

stefanhelzle0001
September 13, 2024

Please provide more details.

mikes0011
Brainy
September 13, 2024

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).

somasundaram.d
September 15, 2024

It is tough to figure out with the provided details. Please provide your expression rule code to analyse further

konduruc733182
September 16, 2024

Hello [mention:c1fa6f7b43464379ab8f31768144b6f8:e9ed411860ed4f2ba0265705b8793d05] 

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.

karumurua531442
September 16, 2024

Hi,[mention:c1fa6f7b43464379ab8f31768144b6f8:e9ed411860ed4f2ba0265705b8793d05] 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?

davidj137213
September 16, 2024

Share your code please..... 

Do you see any errors in tomcat-stdout.log?

Does the SP works as expected when executed in DDBB?