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