SQLTeam.com | Weblogs | Forums

Call statement for multiple cursor - Stored Proc

I have declared 3 cursors to get the below 3 conditions in a Stored Proc , while executing getting an error which says

SQL State: 42704 Vendor Code: -204

I do have the access to run this call statement and the error is misleading, can anyone faced this ?

Parameters :
IN_CARNBR - INPUT - FOR CARD NUMBER
IN_MBRF - INPUT - FOR SEARCH OPTION - 0 - ALL , 1 - INDIVIDUAL , 2 - PRIMARY
IN_CARSTF - INPUT - FOR STATUS OPTION - 0 - ALL , 1 - ACTIVE , 2 - INACTIVE
OUT_CD - OUTPUT - FOR OUT CODE
OUT_MSG - OUTPUT - FOR OUT MESSAGE

Is this for microsoft sql server?

No, Cosmos DB

As stated in many answers to of your previous questions you might be better off asking in a CosmosDb forum

https://social.msdn.microsoft.com/Forums/en-US/home?forum=azurecosmosdb