Question

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?

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

November 17, 2015 - 8:32pm

Are you returning multiple resultsets in your stored proc? Use multiset keyword if that is the case: https://pdn.pega.com/sites/pdn.pega.com/files/help_v719/procomhelpmain.htm#rule-/rule-connect-/rule-connect-sql/sqlguide…

November 18, 2015 - 11:22am
Response to KevinZheng_GCS

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 ','.