#Appian16.2 using Execute Stored Procedure Smart Service, not showing any Result

Pankaj Kabdal

Certified Senior Developer

over 8 years ago

#Appian16.2 using Execute Stored Procedure Smart Service, not showing any Result in output parameter Tab like success and error msg, and also not getting input and output parameter in output while calling from expression rule.

Output from Rule
[success:true,error:,parameters:[],result:]

Discussion posts and replies are publicly visible

0 sanjays0006 over 8 years ago

By Default you would not be able to see the Out Parameter for Execute Stored procedure. We have to manually configure it.

Please go through the pdf document for this plugin:
forum.appian.com/.../summary
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Pankaj Kabdal
Certified Senior Developer
over 8 years ago

Thanks Sanjay, i am able to get result set as per the document but i want output as in like SP Execute Status, Error msg if anything etc.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 abhinavg712
Certified Lead Developer
over 8 years ago

Are you able to get the response in SQL editor , if yes try seeing the Appian logs.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sanjays0006 over 8 years ago

Can you handle error or success as a response from the Stored procedure itself so that we can get error or success as output of the stored procedure?
You can declare input as well as output parameters for a stored procedure.
You can configure the result, error or success like the way you have captured result.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ravi Roshan over 8 years ago

What is the type of in parameter in your procedure, if it is CLOB type in that case it will not return any value. In Execute Stored procedure plugin CLOB input type is not handled, as per my research.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 shwetap02
A Score Level 1
over 5 years ago in reply to sanjays0006

hi sanjay i am not able to access this link pls help
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Peter Lewis
Appian Employee
over 5 years ago in reply to shwetap02

It's now available via the app market. When you download the file using the button on the right, it will contain the PDF mentioned here: https://community.appian.com/b/appmarket/posts/execute-stored-procedure
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 vimalkumars
Certified Lead Developer
over 5 years ago in reply to shwetap02

Here is the link to Execute Stored Procedure in App Market - https://community.appian.com/b/appmarket/posts/execute-stored-procedure#

When you download the plugin. The zip file will contain the documentation and jar.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel