create or alter procedure sp_ttt as begin end; commit;
recreate table ttt (id int); commit;
set term ^;
create or alter procedure sp_ttt
as
    declare k int;
begin
     : k = 1; -- ::: NB :: двоеточие перед именем переменной

    insert into ttt(id) values(100);

end
^
set term ;^
commit;

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 6, column 5.
:.