I am trying to check the domain part of an email before a user is allowed to register.
`#OWNER#.REGISTER_CUSTOMER(
IN_USERNAME => :P102__USERNAME,
IN_PASSWORD => :P102__PASSWORD,
IN_FORENAME => :P102__FORENAME,
IF IN_EMAIL LIKE '@% study.beds.ac.uk' THEN
{IN_EMAIL => :P102__EMAIL,}
END IF;
IN_TEL => :P102__TEL,
IN_SURNAME => :P102__SURNAME);`
Unfortunately, it does not appear to be working and gives me this error code.
ora_sqlerrm: ORA-06550: line 5, column 1: PLS-00103: Encountered the symbol "IF" when expecting one of the following: ( - + case mod new not null continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date pipe
Much thanks in advice for your help.
'@% study.beds.ac.uk'
– Jeffrey Kemp