By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
create or replace TYPE "TYPE_TABNUMBER" as table of number ;
DECLARE
BK1 TYPE_TABNUMBER;
begin
BK1 := 48715788;
END;
/
ORA-06550: line 4, column 12:
PLS-00382: expression is of wrong type
ORA-06550: line 4, column 5:
PL/SQL: Statement ignored
DECLARE
BK1 TYPE_TABNUMBER;
begin
BK1 := TYPE_TABNUMBER(48715788);
END;
/
1 rows affected
DECLARE
BK1 TYPE_TABNUMBER;
begin
BK1 := TYPE_TABNUMBER();
BK1.EXTEND();
BK1(BK1.COUNT) := 48715788;
END;
/
1 rows affected