Convert PL/SQL block returning html to a plugin - render function
WaggersApr 4 2012 — edited Apr 4 2012I have a PL/SQL region that uses htp.p('...') to output HTML. It's dynamic in that it uses a page value to call data from the database. I'd like this region to appear on every page in my application, but also to have the ability to update it once rather than having to update a copy on every page.
From my limited understanding of ApEx the best way to achieve this is to convert my PL/SQL region to a Plugin. I've copied my PL/SQL code into the plugin's source and set the plugin's type to "region" but when I try to load a page that I've added it to, it displays the error "No render function has been defined for plug-in [PLUGIN NAME]".
How do I define a render function? Or is there a better way to achieve what I'm after?