I am trying to populate an page item help text with dynamic (SQL) generated HTML.
Currently I have a "Before Header" process that is populating a "Page Item" "P123_PROCESS_HELP" with SQL Example:
SELECT '<b>Process Control:</b><br><li>Step 1</li><li>Step 2</li><li>Step 3</li>'
FROM DUAL;
- this works great and displays properly in the page item. Then I add "&P123_PROCESS_HELP." to "P123_PROCESS" Help Text attribute and the display is the text along with the HTML tags.
If I take the output from the query and put it into "P123_PROCESS" Help Text it works/displays perfectly. Is there any way to process the HTML so it doesn't display the HTML tags?
TIA
Vinish Kapoor
For this purpose, you should use PL/SQL dynamic content option. Check the following link:
PL/SQL Dynamic Content Exampple