====== pears.FormatPersonAddress ======
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
===== Original SQL =====
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."FormatPersonAddress" IS
{create function FormatPersonAddress
/* Application Maintained Function / Procedure - DO NOT EDIT*/
(in ReqPersonID char(20),in Capitalise smallint,in Style char(1))
returns long varchar
begin
declare FormattedAddress char(300);
set FormattedAddress=FormatPersonAddress1_0(ReqPersonID,Capitalise,Style);
return FormattedAddress
end
}