How can I force an off the shelf application (whose code I can't change) to update a column in their schema to only upper case.
I thought of using a trigger on the table for update or insert but would that not cause mutating error ora-04091 ?
Any help will be appreciated.
create table test (my_char varchar2(10));
create or replace trigger biur_test before insert or update on test
for each row
:new.my_char := upper(:new.my_char);
insert into test values ('a');
select * from test;
Thanks SlimDave. That's exaclty what I wanted.
Click Here to Expand Forum to Full Width