I have this code as follows
Code:
EXEC SQL FETCH getContractParamInfo2 INTO :db_sh_param_type,:db_sh_param_value, :db_createDate ,:db_createEndDate, :db_sncode, :db_spcode;
fetchStatus2 = sqlca.sqlcode;
if(0 == fetchStatus2)
{
ContractParameters tmpContractParam;
JSTRING_FROM_ORA(tmpContractParam.paramType, db_sh_param_type);
JSTRING_FROM_ORA(tmpContractParam.paramValue, db_sh_param_value);
if (tmpContractParam.paramValue LIKE CONCAT('%',tmpContractParam.paramType))
{
do my things here
}
}
The code I am trying to do is highlighted in bold and I know it is wrong.
Is there any other way of doing it? If so, is there any code example?