I have an IF statement in my code which is failing the compiler.
I am on Oracle 22.214.171.124
if r_dist.dst_gl_dist_revclass IS NULL then
elseif r_wip.dsti_revenue_class = r_dist.dst_gl_dist_revclass then
else v_misMatch := 1;
the compiler returns:
ORA-06550: line 37, column 8:
PLS-00103: Encountered the symbol "R_WIP" when expecting one of the following:
:= . ( @ % ;
The symbol ":=" was substituted for "R_WIP" to continue.
ORA-06550: line 37, column 43:
PLS-00103: Encountered the symbol "THEN" when expecting one of the following:
. ( * @ % & - + ; / at mod rem <an exponent (**)> and or ||