pears.VacancyDetailsContents

CREATE FUNCTION "pears"."VacancyDetailsContents"( IN @SMSOrEmail CHAR(1),IN @CandidateOrVacancy CHAR(1),IN @ProgressIDs long VARCHAR ) 
RETURNS long VARCHAR
BEGIN
  -- @SMSorEmail S or E, @CandidateOrVacancy C or V, @ProgressIDs ID1,ID2... for sa_split_list(@ProgressIDs) 
  -- sample for candidate
  --   select first name into rv from person key join progress join sa_split_list(@ProgressIDs) on progress.progressid = Row_value;
  -- sample for vacancy
  --   select first vacancyid into rv from progress join sa_split_list(@ProgressIDs) on progress.progressid = Row_value;
  DECLARE "rv" long VARCHAR;
  SET "rv" = '';
  RETURN "rv"
END