Hi
I've following table
table1 (
fld1 number(5) primary key,
fld2 varchar2(20),
fld3 varchar3)

I want a trigger which can stop certain values.
I tried with raise_application_error() proc. But then Oracle cries to handle an unhandled exception. If i'm handling it then then new values gets inserted into table:(

Please Help
Prabodh

__________________
Prabodh

i think you should handle this in the frontend and not in backend database.

Amol N. Kataria

1) Try making use of CHECK constraint.
2)You can simply write if-else block
   if :new values are proper
         Insert statement.
   end if;

Regards
Milind