---
title: "Discussion on \"Wrapping APEX_MAIL & Using JSON_OBJECT_T for Placeholders\" | Hashnode"
description: "Discussion on \"Wrapping APEX_MAIL & Using JSON_OBJECT_T for Placeholders\". Learn how to wrap APEX_MAIL with a PL/SQL API and use JSON_OBJECT_T for efficient email placeholder management."
url: "https://hashnode.com/posts/wrapping-apexmail-and-placeholders/68b03964d29a0ce6246c467c"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Wrapping APEX\_MAIL & Using JSON\_OBJECT\_T for Placeholders](https://blog.cloudnueva.com/wrapping-apexmail-and-placeholders?utm_source=hashnode&utm_medium=feed)

Learn how to wrap APEX\_MAIL with a PL/SQL API and use JSON\_OBJECT\_T for efficient email placeholder management.

Aug 28, 2025 · 4 min read · blog.cloudnueva.com  
Read the article

-   [#orclapex](https://hashnode.com/tag/orclapex)
-   [#oracle-apex](https://hashnode.com/tag/oracle-apex)
-   [#json](https://hashnode.com/tag/json)

## Written by

[Jon Dixon](https://hashnode.com/@orclapex)

@orclapex · San Diego, CA

  
[View profile](https://hashnode.com/@orclapex)

APEX, ORDS & the Oracle Database

I’m Jon Dixon, an Oracle APEX developer and consultant at Cloud Nueva. I write about APEX, ORDS, the Oracle Database, and how AI is changing the way we build software. This blog is where I share practical examples, lessons learned, and ideas from my work.

## Responses 1

Markdown supported · ⌘↵ to post

[Alex Bershtansky](https://hashnode.com/@alexbrs1)

[Aug 31, 2025](https://hashnode.com/posts/wrapping-apexmail-and-placeholders/68b03964d29a0ce6246c467c/comment/68b422a85f2aa2e01fdc096d)

if i need to draw in mail body multirecord table do u have solution for that?: json arrays? Loop block for arrays?

[Jon Dixon](https://hashnode.com/@orclapex)

[Sep 1, 2025](https://hashnode.com/posts/wrapping-apexmail-and-placeholders/68b03964d29a0ce6246c467c/comment/68b422a85f2aa2e01fdc096d#reply-68b62bc40ea535085937e4d1)

Hi, I usually generate the HTML via PL/SQL, then include the table in the Email using the !RAW substitution syntax, e.g., #EMAIL\_BODY!RAW# Described in this post: [tm-apex.hashnode.dev/display-tabular-data-in-an-e…](https://tm-apex.hashnode.dev/display-tabular-data-in-an-email-apex-mail-6.) You can then use CSS in the email template to do the coloring, e.g., [blog.cloudnueva.com/apex-email-templates-advanced…](https://blog.cloudnueva.com/apex-email-templates-advanced-formatting#heading-in-line-custom-css)