Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
0


select length('four') len
     , greatest(3,4) largest
  from dual
;


LEN
LARGEST


4
4


create or replace package p as
  vc varchar2(4);
end;
/
create or replace package p as
  vc varchar2(length('four'));
end;
/
create or replace package p as
  vc varchar2(length('four') * 2);
end;
/
create or replace package p as
  vc varchar2(greatest(3,4)); --PLS-00491: numeric literal required
end;
/
ORA-24344: success with compilation error

select * from user_errors;


NAME
TYPE
SEQUENCE
LINE
POSITION
TEXT
ATTRIBUTE
MESSAGE_NUMBER


P
PACKAGE
1
2
15
PLS-00491: numeric literal required
ERROR
491