In APEX 24.1, I'm loading some page item values using SQL and Set Value on page load. Then I'm trying to merge them with some HTML content in a Static Content region like… Some text &item_name. some more text. But the values are not appearing in the HTML when I run the page, although I can see the values displayed in the items.
I'm thinking it must be a timing issue, because if I set the item values using individual SQLs in the item properties, then I do get the values, and they are displayed in the HTML content.
What am I missing here?