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 |