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