I have this code as follows
The code I am trying to do is highlighted in bold and I know it is wrong.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 } }
Is there any other way of doing it? If so, is there any code example?



LinkBack URL
About LinkBacks


