jeudi 18 janvier 2018

PLS-00103: Encountered the symbol "IF" without "when expecting ..."

I get "Encountered the symbol "IF"" error without any "when expecting ..." after that. My simplified code looks like this:

declare
begin
 with ()
 select <some value> into My_output
 EXCEPTION WHEN NO_DATA_FOUND then
  My_output := NULL;
 END;
 if My_output is not NULL then
  <Statement>
 end if;
end;

Aucun commentaire:

Enregistrer un commentaire