function cf_calc_maxformula return number is 
begin
if :sal=:cs_max_sal then
:cp_max_earner := (:ename||'in department'|| :deptno);
end if;
return(0);
end;

SQL> select 'scott' || ' in department ' || 10 from dual;

'SCOTT'||'INDEPARTMENT
----------------------
scott in department 10

SQL> declare
  2    l_var varchar2(200);
  3  begin
  4    l_var := 'scott' || ' in department ' || 10;
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL>

SQL> l
  1  declare
  2    l_var varchar2(10);
  3  begin
  4    l_var := 'scott' || ' in department ' || 10;
  5* end;
SQL> /
declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 4


SQL>