Hi Team, I am using the "Execute Stored Procedure" smart service

georgej over 8 years ago

Hi Team,
I am using the "Execute Stored Procedure" smart service from one of my process models. Everything looks except that I am not getting the result set returned via Cursor from the stored procedure. The cursor holds a single column which is numeric ; the stored procedure is used for updating some tables ,the updates are working fine. Also I am able to retrieve the values passed via OUT parameters. DB is Oracle. Could you please provide some directions for further trouble shooting.

Discussion posts and replies are publicly visible

Parents

0 Tom Ryan
Appian Employee
over 8 years ago

Based on my understanding of your use case I am not sure that this is a feature of the plugin. However, as per the instruction documentation in the Shared Component page here

forum.appian.com/.../o

you should be able to get some more information as to what is going on by increasing the plugin logging level in <Appian Home>/ear/suite.ear/resources/appian_log4j.properties:

log4j.logger.com.appiancorp.ps.ss=DEBUG
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Tom Ryan
Appian Employee
over 8 years ago

Based on my understanding of your use case I am not sure that this is a feature of the plugin. However, as per the instruction documentation in the Shared Component page here

forum.appian.com/.../o

you should be able to get some more information as to what is going on by increasing the plugin logging level in <Appian Home>/ear/suite.ear/resources/appian_log4j.properties:

log4j.logger.com.appiancorp.ps.ss=DEBUG
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data