Question
2
Replies
475
Views
Virtusa Corp.
Posted: February 7, 2016
Last activity: February 11, 2016
Closed
Solved
Stored Procedure is throwing error. however, dynamic SQL works fine.
Facing issue while calling stored procedure from pega. same SP is working fine from IBM data studio and dynamic SQL is working fine too.
Error:
There was a problem getting a list: code: -104 SQLState: 42601 Message: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=EXEC;<ERR_STMT> <WNG_STMT> GET SQL SAVEPOINT HOLD FREE ASSOCIATE, DRIVER=4.18.60
Pega Version: Pega 7.1.7 Version
Database: DB2
Accepted Solution
Posted: 5 years ago
Kevin, Thanks for the reply.
Issue is resolved by passing OUT parameters.
Please elaborate more details:
1. Are you using connect-sql?
2. How exactly did you call the SP from Pega? Share the SP details if possible.
It would also be helpful if you attach the db trace from Pega.