Hi there,

Can anyone tell me why the following does work in Oracle8i but not in Oracle9i?

declare
myvar BOOLEAN := false;
c_True CONSTANT BOOLEAN := true;
begin
select c_True into myvar from dual;
end;

I get "PLS-00382: expression is of wrong type" when running this in Oracle9i, but no error is returned when an Oracle8i database is used.

Thanks in advance,
Javi