Does anybody know what all things should be passed into the smart service "

aswinb over 9 years ago

Does anybody know what all things should be passed into the smart service "Execute Stored Procedure". There seems to be no description of this node inside forum documentation. I passed in Data Source Name as the environment where the stored procedure is located. Then for the procedure name I passed in the name of the stored procedure. And then created ac's for all parameters in the stored procedure and finally created a result set called "resultSet1" and saved it into a pv of correct type. But I don't seem to get any output. The stored procedure node executes successfully but it's just that I am not getting any output. Anybody have any ideas?...

Discussion posts and replies are publicly visible

0 Bishnu Panigrahi
Appian Employee
over 9 years ago

This is a plugin that can be found in the Shared Components record. Go to Records --> Shared Components --> Execute Stored Procedure. There you will find the documentation for this node.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aswinb over 9 years ago

thank you...Bishnu
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Luis Alberto Peña over 4 years ago in reply to aswinb

can you please provide an example? we do not have access to the documentation
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ChristineH
Certified Lead Developer
over 4 years ago

The ones that should appear on Data > Inputs are:

- Data Source Name: value should be like jdbc/AppianDS

- Procedure Name: case sensitive name of your stored proc to call

- Pause on Error: True/False

- Ru Validation: True/False

Then you need to add any IN / OUT parameters - in order and case sensitive

Hope that helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel