Trying to assign a large character value to a smaller variable or column will raise an error.
Noncompliant code example
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;
Compliant solution
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;
