APEX

Hi -

I am getting the below error while running a date validation. The below code looks fine but I am not able to figure out why I am getting this error.

Error Message

ORA-06550: line 1, column 34: PLS-00103: Encountered the symbol "DECLARE" when expecting one of the following: ( ) - + case mod new not null table continue avg count current exists max min prior sql stddev sum variance execute multiset the both leading trailing forall merge year month day hour minute second timezone_hour timezone_minute timezone_region timezone_abbr time timestamp interval date


ERR-1025 Error processing PLSQL expression. declare
l_entered_date date;
begin
select APPRVL_DT into l_already_entered_date from xx_xx
where my_id = :p100_my_id;

if (to_date(:P100_APPRVL_DT,'mm/dd/yyyy') <> l_entered_date) and
(to_date(:P100_APPRVL_DT,'mm/dd/yyyy') < trunc(sysdate)) then
return false;
else
return true;
end if;
end;

Version apex 3.2

Thanks for the help.

Regards,
Greenhorn