hi,
I'm trying to test if a name is known in a table before executing
some operation or to raise an exception, but it seems i've done
something wrong, let's have a look :

...
begin
if (:s_name not in (select pilotename from pilote)) then
begin
exception data_error;
end
else
begin
...


I have : "subselect illegal in this context", can you tell me why,
please ?