NSArray<NSDictionary> results;
NSDictionary<String,String> args = new NSDictionary<String,String>(searchString,"search");
results = EOUtilities.rawRowsForStoredProcedureNamed(ec,"FindZips",args);
I get the following error from the rawRowsForStoredProcedureNamed method:
EvaluateExpression failed: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: \"{ call find_zips (?)}\" withBindings: 1:\"04103\"(search)>:\n Next exception:SQL State:42000 -- error code: 1305 -- msg: FUNCTION find_zips does not exist
It seems to me the call being generated is correct and since the procedure exists (and is being used by non-WO code without problem) am a bit stuck. I'm probably missing something obvious as new to WO so anyone got any ideas?
Thanks
Mark