Test as below
create table x (a number, b varchar2(100 byte) primary key);
create table y (c varchar2(30 BYTE), d number,
foreign key(c) references x (b) on delete cascade);
Insert into X (A,B) values (2,'abcdefghijklmnopqrstuvwxyzabcdefg');
Insert into X (A,B) values (3,'abcdefghijklmnopqrstuvwxyzabcdefgi');
Insert into X (A,B) values (4,'abcdefghijklmnopqrstuvwxyz abcdf');
Insert into X (A,B) values (5,'abcdefghijklmnopqrstuvwxyz abcdfg');
Insert into X (A,B) values (6,'abcdefghijklmnopqrstuvwxyz abcdfgi');
Try
delete from x where a = 3;
and
delete from x where a = 3will be thrown on Oracle versions 10.2 and 11.1 but not in 11.2
*
ERROR at line 1:
ORA-01460: unimplemented or unreasonable conversion requested
On 11.2 the delete operation will suceed without an error.
To fix the problem both referred and referrenced columns should have the same scale
ie. both should be varchar2(100 byte) for this example. Once the change is made delete operation will work on both 10.2 and 11.1