Re: Let Oracle truncate values on INSERT autom.

how about an on insert trigger?

CREATE OR REPLACE TRIGGER trunc_values
BEFORE INSERT ON your_table
REFERENCING new AS new old AS old
FOR EACH ROW
WHEN (length(new.your_row) > 10)
yadda yadda ...

(not sure if you can put your (new.your_row) inside a function like that because of the new, but try it and see if it works -- it should).

"news.netcologne.de" <joerg.jung_at_clarity-ag.net> wrote in message news:<a4itak$e76$1_at_news.netcologne.de>...
> hi,
>
> is there a way to force oracle to truncate too large values automatically on
> an per insert base ?
>
> thanx for help, jj
Received on Fri Feb 15 2002 - 11:00:39 CST