Re: Inserting through a view - forcing certain values into columns

In article <45F5407B.2080505_at_arcor.de>, Maxim Demenko says...

> SQL> create or replace view mytab_v
> 2 as
> 3 (select *
> 4 from mytab
> 5 where filter_col = 'Y')
> 6 with check option;
>
> View created.
>
> SQL>
> SQL> insert into mytab_v (id, name, filter_col)
> 2 values (1, 'xxx','N');
> insert into mytab_v (id, name, filter_col)
> *
> ERROR at line 1:
> ORA-01402: view WITH CHECK OPTION where-clause violation
>
>

<slaps forehead>
Probably been around since oracle version 6....

-- 
jeremy