TRUE FALSE "invalid identifier"?
436909Mar 22 2005 — edited Mar 22 2005Hi,
suppose I write the following code:
declare
a boolean := FALSE;
b varchar2(10);
begin
select decode(a,TRUE, 'a is true', FALSE, 'a is false', 'no idea what a is') into b from dual;
dbms_output.put_line(b);
end;
What's wrong with it, that I get "ORA-00904: "FALSE": invalid identifier"? Is there a limitation in the use of boolean vars?
Thanks a lot in advance