Can anyone tell me why the following does work in Oracle8i but not in Oracle9i?
myvar BOOLEAN := false;
c_True CONSTANT BOOLEAN := true;
select c_True into myvar from dual;
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,