Is there a way to format an address for printing (like in an emailed document generated from custom PL/SQL) without the extra blank lines that come from concatenating empty address-field lines together?

Q: Is there a way to format an address for printing (like in an emailed document generated from custom PL/SQL) without the extra blank lines that come from concatenating empty address-field lines together?

Use Address_Presentation_API.Format_Address, passing the country and the individual address-line fields, rather than concatenating the raw address fields yourself — this function applies the same per-country formatting rules configured on the Address Presentation page (the ones the standard client already uses), which correctly skips blank lines instead of leaving gaps where an address field happens to be empty.

Answer

Use Address_Presentation_API.Format_Address, passing the country and the individual address-line fields, rather than concatenating the raw address fields yourself — this function applies the same per-country formatting rules configured on the Address Presentation page (the ones the standard client already uses), which correctly skips blank lines instead of leaving gaps where an address field happens to be empty.

← Browse Integrations and APIs questions