create or replace
function vdep (d departments.department_id%type)
return boolean is b boolean;
e departments.department_id%type;
begin
select department_id
into e
from departments
where department_id = d;
if e = null then b := false;
else b := true;
end if;
return b;
end;
/
set serveroutput on
variable b boolean
begin
:b := vdep(60);
end;
print b
i get the next error Bind Variable "b" is NOT DECLARED