I was just thinking if i can do this process automatically transparent to application .

basically there might be several screens in oracle forms application where this thing might be present.

also i guess some of you might have noticed there is a bug in 10g in particular .

if you have master tale and child table and if you insert records in master table . child tables are locked . i raised this bug for 10g BUG:4309859 SLOW DML I....

you will notiice this lock if you have something of this kind in large scale . like 1 master table and 1000 child tables.

but the same insert in 8i database will work 40 times faster.

did anyone tried this type of insert 9i ?