Hi
I'm having some issues getting a date into a column header for a tab report I am creating.
this thread
934994
suggested using a hidden item and having a pl/sql function body and including the item in the header.
So I set the Column title up with "Outdoors <br> &P1120_DISPLAY_DATE"
In the item source I set
begin
:P1120_DISPLAY_DATE := sysdate;
end;
However I end up with a syntax error message when the page starts to draw ...
ORA-06550: line 1, column 27: PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following: ( - + case mod new not null avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date pipe
Error ERR-1020 Error in PLSQL item processing (function).
When I just use sysdate as a test method ( no additional pl/sql) the error goes but the item does not appear to be set. In the Column title I get the item name not the value.
I wanted to have the column set to Outdoors <br> 12-Mar-05
Appreciate some guidance on this one.
Stephen