Show pageOld revisionsBacklinksExport to PDFFold/unfold allBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== pears.DocumentPackEmailBody ====== <WRAP center round info> Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. </WRAP> ===== Original SQL ===== <code sql> create function "pears"."DocumentPackEmailBody"( in "persid" char(20),in "vacid" char(20),in "oldbody" long varchar ) returns long varchar begin declare "rv" long varchar; declare "CRLF" char(2); declare "deptid" char(2); select "departmentid" into "deptid" from "vacancy" where "vacancyid" = "vacid"; set "crlf" = "char"(13)+"char"(10); set "rv" = "string"('Dear ...',"CRLF","CRLF","oldbody"); -- use persid to get person questions -- use vacid to get vacancy questions return("rv") end </code> database/functions/pears_documentpackemailbody.txt Last modified: 2026/08/07 19:24by 127.0.0.1