APEX

Hi,

Hoping someone cleverer than I can assist.

I have an image map, which has four areas on it that I wish to display some dynamic text (dates) that will change depending on lookups or formulas.

However my first attempt to get one of these to work is failing. I have an item called P12_BLACKOUT_DATE on the page which I am trying to assign a value to via the following code in a computation that triggers before the headers

SELECT TRUNC(NEXT_DAY(NEXT_DAY(SYSTIMESTAMP - (12 / 24), 'WED'), 'THU') + 7) into :P12_BLACKOUT_DATE FROM DUAL;

In the code for the image map I have to following line

...<div class="blackout">&P12_BLACKOUT_DATE.</div>...

But when I run the page I get the following error

ORA-20001: Unable to bind P12_BLACKOUT_DATE verify length of item is 30 bytes or less. Use v() syntax to reference items longer than 30 bytes. ORA-01006: bind variable does not exist

As you can see in the screenshot the items are there, I just dont understand what I need to do to get this to work

Any help would be appreciated