Re: Need help quick!!
From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 27 Jan 2003 13:16:22 -0800
Message-ID: <1b061893.0301271316.18314ed7_at_posting.google.com>
Date: 27 Jan 2003 13:16:22 -0800
Message-ID: <1b061893.0301271316.18314ed7_at_posting.google.com>
What you need is a trigger. Something like:
create or replace trigger client_ins
before insert on client
for each row
begin
if "UNACCEPTABLE_VALUE" then
raise_application_error(-20100,'Your Error message here!');
end if;
exception
when others then
null;
end client_ins;
/
Replace "UNACCEPTABLE_VALUE" with what you try to catch. You can also create your own exceptions if you want, and you can also deal with Oracle's pre-defined exceptions (see the list of them in entry "Exception" of SQL reference book).
Daniel Received on Mon Jan 27 2003 - 22:16:22 CET