SQL & PL/SQL

I have the following code:

int fetchStatus = 0, counter = 0;
int prev_sh_param_type = 0;
jString tmp_st_date;
jString tmp_st_end_date;
jString tmp_st_start_date_c;
jString tmp_st_end_date_c;


EXEC SQL BEGIN DECLARE SECTION;
VARCHAR db_sh_param_value[100];
varchar db_sh_param_type[MAX_BUF];
int db_param_contr_id;
int db_sncode;
int db_spcode;
varchar db_maxDate[MAX_BUF];
varchar db_createDate[MAX_BUF];
varchar db_createEndDate[MAX_BUF];
varchar db_BillingEndDate[MAX_BUF];
varchar db_BillingStartDate[MAX_BUF];
EXEC SQL END DECLARE SECTION;

db_param_contr_id = ThisContract.ContractId.intValue();


JSTRING_TO_ORA(db_BillingEndDate, defaultEndTime.format("%Y%m%d"));
JSTRING_TO_ORA(db_BillingStartDate,defaultStartTime.format("%Y%m%d"));

EXEC SQL DECLARE getContractParamInfo CURSOR FOR
SELECT SHPARAM_TYPE,
SHPARAM_VALUE,
to_char(SHPARAMDATE, 'YYYYMMDD'),
NVL(to_char(SHPARAMENDDATE,'YYYYMMDD'),:db_BillingEndDate),
SHSNCODE,
SHSPCODE
FROM sh_display_param
WHERE CEH_CO_ID = :db_param_contr_id
AND to_char(shparamdate,'YYYYMMDD') <= :db_BillingEndDate
ORDER BY SHPARAM_TYPE, SHPARAMDATE desc;

fetchStatus = sqlca.sqlcode;

My variable fetchStatus is 0 and processed when the first record is processed. However, for my 2nd record, it is not processed and my fetchstatus is set as 1403.

How do I reset my variable so that for my 2nd record, fetchStatus variable is set as 0?