New Rule: assign strings only to variables / columns with adequate size about plsql-and-sql-coding-guidelines HOT 2 CLOSED

create table persons (id number, name varchar2(4));

insert into persons (id, name) values (1, 'Alice'); -- Noncompliant, raises ORA-12899

create or replace procedure sp1
is
  foo varchar2(2);
begin
  select name into foo from persons where id = 1; -- Noncompliant, may raise ORA-06502
end;

create table persons (id number, name varchar2(8));

insert into persons (id, name) values (1, 'Alice');

create or replace procedure sp1
is
  foo varchar2(8);
begin
  select name into foo from persons where id = 1;
end;