-
Gentlemen:
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.
MS
-
create table test (my_char varchar2(10));
create or replace trigger biur_test before insert or update on test
for each row
begin
:new.my_char := upper(:new.my_char);
end;
/
insert into test values ('a');
select * from test;
MY_CHAR
----------
A
-
Thanks SlimDave. That's exaclty what I wanted.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|