Inserting rows although the raise_application_error is raised
sgalaxyJun 27 2007 — edited Aug 7 2007Hi,
I have created two triggers on a table (one before insert and the other after insert).
The after trigger calls a procedure...
The before insert trigger is as follows:
create or replace trg_
before insert on xf
or each row
begin
select a_date from y
where ...;
if x>:new.date_of_a_table_inserted_via_a_form
then
raise_application_error....
end if;
end;
Altough i insert a date value equal to a_date - not previous to a date which has already been inserted the trigger displays the error message (raise_application_error....(message)) but the row(s) are inserted....in the table.... Can you spot what may be wrong...????
many thanks,
Simon