Skip to main content
Participating Frequently
Sep 13, 2024 10:20 AM UTC
Question

Stored Procedure output Not Visible in appian .


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
Brainy
Sep 13, 2024 7:13 PM UTC

Please provide more details.

mikes0011
Brainy
Sep 13, 2024 7:39 PM UTC

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

The Expression Guru
somasundaram.d
Employee
Sep 15, 2024 2:05 PM UTC

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

konduruc733182
Inspiring
Sep 16, 2024 3:24 AM UTC

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
Participating Frequently
Sep 16, 2024 4:00 AM UTC

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
Brainy
Sep 16, 2024 7:01 AM UTC

Share your code please..... 

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

Does the SP works as expected when executed in DDBB?