Question
U.S. Dept of Veterans Affairs
U.S. Dept of Veterans Affairs
US
U.S. Dept of Veterans Affairs
Posted: Nov 17, 2015
Last activity: Nov 18, 2015
Last activity: 18 Nov 2015 11:22 EST
Closed
stored procedure Issue
we are trying to get the results from DB(MS SQL Serever) through stored procedure but getting the below error
| Message | There was a problem getting a list: code: 16937 SQLState: S0002 Message: A server cursor cannot be opened on the given statement or statements. Use a default result set or client cursor. |
Syntax used in Browse tab -
\{call DB.dbo.getData({TempPage.PONum},{temp1 out})\}
temp1 - is page with Code-Pega-List.
Any idea on this error?
Posted: 9 years ago
PEGA
Pegasystems Inc.
US
Are you returning multiple resultsets in your stored proc? Use multiset keyword if that is the case: https://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm
Posted: 9 years ago
U.S. Dept of Veterans Affairs
U.S. Dept of Veterans Affairs
US
No.....the SP returns just 1 row always. However I tried with multiset option also like \{call DB.dbo.getData({TempPage.PONum},{temp1 out},{multiset})\}. Got the below error
There was a problem getting a list: code: 102 SQLState: S0001 Message: Incorrect syntax near ','.